Re: Counterfeit books “shipped and sold by Amazon”?
This happens because Amazon allows inventory commingling. For example Amazon has their own, legitimate inventory in a West Coast warehouse, and a third party seller has the same inventory with the original UPC manufacturer bar code on it, sitting in an East Coast warehouse. Amazon considers this 1:1 inventory. Amazon will debit their inventory on the West Coast, and credit the inventory that belongs to the third party seller on the East Coast but they will send the inventory from the East Coast to the customer since it's closer to them.
Now in theory this seems like a reasonable approach to deliver products to customers faster, the catch 22 is that third party vendors have clearly taken advantage of Amazon's complete lack of quality control. Third party sellers can sign up for a Seller Central account, and send in counterfeit products with fake bar codes because Amazon doesn't check at all.
I could sit here and talk for hours about mess that is Seller Central. I've dabbled with Fulfilled by Amazon (FBA), and I would never recommend any company use AMZN for third party logistics.
mariomariomario, 3 hours ago
This happens because Amazon allows inventory commingling. For example Amazon has their own, legitimate inventory in a West Coast warehouse, and a third party seller has the same inventory with the original UPC manufacturer bar code on it, sitting in an East Coast warehouse. Amazon considers this 1:1 inventory. Amazon will debit their inventory on the West Coast, and credit the inventory that belongs to the third party seller on the East Coast but they will send the inventory from the East Coast to the customer since it's closer to them.
Now in theory this seems like a reasonable approach to deliver products to customers faster, the catch 22 is that third party vendors have clearly taken advantage of Amazon's complete lack of quality control. Third party sellers can sign up for a Seller Central account, and send in counterfeit products with fake bar codes because Amazon doesn't check at all.
I could sit here and talk for hours about mess that is Seller Central. I've dabbled with Fulfilled by Amazon (FBA), and I would never recommend any company use AMZN for third party logistics.
mariomariomario, 3 hours ago
Re: Costco gained a cult following by breaking every r...
The fact that I can trust Costco to have good quality products with low prices and great return policy means that I never have to buy day-to-day items from Amazon.
Amazon is where I go to buy books (and obscure one-off things that I can't buy from anywhere else). When buying from Amazon, I have to read the reviews, analyze them to figure out if the reviews are fake, read the return policy, research the seller, figure out the shipping dates etc. Given how broken the search is, I am not even sure if I am buying the best item in the category. Most of the time I end up reading wire-cutter reviews before buying from Amazon.
Amazon has billions of items at this point, and it is on me to figure out the right stuff that I should buy. I don't have that kind of time or patience to read hundreds of reviews before buying every single item.
Compared to this, Costco is a breeze. If they carry it, I just buy it assuming that it is going to be good quality. For me, the value they provide is curation of selection and filtering for quality. I am willing to pay the membership fee for this.
And this is anecdotally true for almost all of the families in my friends group in the Seattle area. I can see the perspective that if you don't have a family, the savings are probably not a big deal. And I also agree that there are people who don't want to drive to a store to buy stuff. But, I for one, am glad that Costco exists.
niyazpk, 7 hours ago
The fact that I can trust Costco to have good quality products with low prices and great return policy means that I never have to buy day-to-day items from Amazon.
Amazon is where I go to buy books (and obscure one-off things that I can't buy from anywhere else). When buying from Amazon, I have to read the reviews, analyze them to figure out if the reviews are fake, read the return policy, research the seller, figure out the shipping dates etc. Given how broken the search is, I am not even sure if I am buying the best item in the category. Most of the time I end up reading wire-cutter reviews before buying from Amazon.
Amazon has billions of items at this point, and it is on me to figure out the right stuff that I should buy. I don't have that kind of time or patience to read hundreds of reviews before buying every single item.
Compared to this, Costco is a breeze. If they carry it, I just buy it assuming that it is going to be good quality. For me, the value they provide is curation of selection and filtering for quality. I am willing to pay the membership fee for this.
And this is anecdotally true for almost all of the families in my friends group in the Seattle area. I can see the perspective that if you don't have a family, the savings are probably not a big deal. And I also agree that there are people who don't want to drive to a store to buy stuff. But, I for one, am glad that Costco exists.
niyazpk, 7 hours ago
Re: Flash Is Responsible for the Internet's Most Creat...
During 1999-2000, I helped hundreds of people learn how to use Flash. I was, looking back now, probably one of the top experts on Flash 4 at the time in the world. The twist - I was a 15 year old living in a tiny African country called Lesotho.
Lesotho is pretty isolated from the world. Nobody even knows it exists. Living there, Silicon Valley might as well be on Mars.
However, we used to get issues of Wired Magazine from South Africa, and these came with shareware CDs. These CDs included 30-day trial editions of Macromedia Flash.
Flash was amazing at the time. Being able to create interactive animations blew my mind. I learned Flash 4 completely inside and out. I knew every single feature, every single quirk.
Of course living in Lesotho, there was nothing I could really do with all this. Most people around me didn't even know how to use computers. Flash was several layers of abstraction away from that.
So I used to spend all my time on Yahoo Chat's Web Design chat rooms. Mainly hanging out with nerds in the US. We used to have countless people drop by in the rooms every day asking questions about Flash. Mainly people working for web design agencies in the US. I was the resident Flash expert. Flash questions always were referred to me.
In the 2000s Flash rightly got a lot of flak. I'm not sad it's gone. But it was really something special, especially in the late 90s.
taneem, 3 hours ago
During 1999-2000, I helped hundreds of people learn how to use Flash. I was, looking back now, probably one of the top experts on Flash 4 at the time in the world. The twist - I was a 15 year old living in a tiny African country called Lesotho.
Lesotho is pretty isolated from the world. Nobody even knows it exists. Living there, Silicon Valley might as well be on Mars.
However, we used to get issues of Wired Magazine from South Africa, and these came with shareware CDs. These CDs included 30-day trial editions of Macromedia Flash.
Flash was amazing at the time. Being able to create interactive animations blew my mind. I learned Flash 4 completely inside and out. I knew every single feature, every single quirk.
Of course living in Lesotho, there was nothing I could really do with all this. Most people around me didn't even know how to use computers. Flash was several layers of abstraction away from that.
So I used to spend all my time on Yahoo Chat's Web Design chat rooms. Mainly hanging out with nerds in the US. We used to have countless people drop by in the rooms every day asking questions about Flash. Mainly people working for web design agencies in the US. I was the resident Flash expert. Flash questions always were referred to me.
In the 2000s Flash rightly got a lot of flak. I'm not sad it's gone. But it was really something special, especially in the late 90s.
taneem, 3 hours ago
Re: My Letter to the Editor of New York Times Magazine
Blaming the user is a pernicious problem in UX engineering, especially when a feature is introduced not for the actual users, but the executives making the purchasing decisions.
MCAS was an economics driven decision by Boeing to be able to sell it as a "no cost" upgrade to existing 737 fleets. "You get all this and you don't need to retrain your people"
The entire concept of the 737 MAX was flawed, marketing an inherently unstable aircraft with a patched undocumented system to control that instability. Then, incredibly, making the safety indicators an optional extra was criminal.
The FAA is also liable for regulatory capture and handing over its responsibilities the actual organization it is supposed to be supervising.
Ultimately, it's an example of what happens when MBA execs, convinced that they can run "any business" take over from a rigourous engineering culture. The Harvard (and other) Business Schools have a lot to be blamed for.
rswail, 7 hours ago
Blaming the user is a pernicious problem in UX engineering, especially when a feature is introduced not for the actual users, but the executives making the purchasing decisions.
MCAS was an economics driven decision by Boeing to be able to sell it as a "no cost" upgrade to existing 737 fleets. "You get all this and you don't need to retrain your people"
The entire concept of the 737 MAX was flawed, marketing an inherently unstable aircraft with a patched undocumented system to control that instability. Then, incredibly, making the safety indicators an optional extra was criminal.
The FAA is also liable for regulatory capture and handing over its responsibilities the actual organization it is supposed to be supervising.
Ultimately, it's an example of what happens when MBA execs, convinced that they can run "any business" take over from a rigourous engineering culture. The Harvard (and other) Business Schools have a lot to be blamed for.
rswail, 7 hours ago
Re: Apple of 2019 is the Linux of 2000
1. Never once seen an issue with USB-C to HDMI or VGA connections. It doesn't even make any sense since MacBook Pro users with external, third party monitors are an extremely common combination.
2. I just downloaded Caret (Markdown editor) from their website and used Homebrew to install a CLI tool. Nothing has changed between the current OSX and previous ones.
3. If you have a tech support issue go into the Apple Store and work with them 1-1. Very rare to find anything that someone in the store doesn't know.
4. MacBook Pro has 4 USB-C ports.
5. If you resort to calling groups of people "condescending elitist hipster latte drinkers" then pretty sure you've lost the argument.
threeseed, 2 hours ago
1. Never once seen an issue with USB-C to HDMI or VGA connections. It doesn't even make any sense since MacBook Pro users with external, third party monitors are an extremely common combination.
2. I just downloaded Caret (Markdown editor) from their website and used Homebrew to install a CLI tool. Nothing has changed between the current OSX and previous ones.
3. If you have a tech support issue go into the Apple Store and work with them 1-1. Very rare to find anything that someone in the store doesn't know.
4. MacBook Pro has 4 USB-C ports.
5. If you resort to calling groups of people "condescending elitist hipster latte drinkers" then pretty sure you've lost the argument.
threeseed, 2 hours ago
Re: My Google account got suspended because of NewPipe
Entire lives are wrapped up in Google accounts! They're used for administering other accounts, taxes and payroll, subscriptions, keeping in touch with family, photos...
This could easily ruin someone's life.
What the fuck, Google.
We seriously need to break this company up into its constituent pieces. This is beyond unacceptable.
echelon, 59 minutes ago
Entire lives are wrapped up in Google accounts! They're used for administering other accounts, taxes and payroll, subscriptions, keeping in touch with family, photos...
This could easily ruin someone's life.
What the fuck, Google.
We seriously need to break this company up into its constituent pieces. This is beyond unacceptable.
echelon, 59 minutes ago
Re: Apple of 2019 is the Linux of 2000
Meh. I bailed out of the Mac ecosystem last year, as my mid-2012 retina Macbook was finally getting too creaky, and the latest Mac hardware was a regression in many respects, while simultaneously utterly unaffordable. I'm now dual-booting Ubuntu/Windows 10 on a Dell XPS 15".
What this experience has taught me is that computing in 2019 basically sucks. The problems with 2000-era Linux, as described in the article, are very similar to the problems with 2019-era Linux. External monitors are a particular pain point for me. I've got an HDPI laptop and I want to plug into an old non-HDPI era monitor. Doesn't work. Spend the next 10 hours poking around forums, trying weird XWindows options, installing Wayland, etc. Still doesn't work. Eventually, give up.
Windows 10 works marginally better. Both remain vastly inferior to MacOs.
I'm not saying that the grass isn't greener on the other side. Macs are regressing, but the grass isn't greener on either side. Let's stop pretending otherwise.
nkoren, 3 hours ago
Meh. I bailed out of the Mac ecosystem last year, as my mid-2012 retina Macbook was finally getting too creaky, and the latest Mac hardware was a regression in many respects, while simultaneously utterly unaffordable. I'm now dual-booting Ubuntu/Windows 10 on a Dell XPS 15".
What this experience has taught me is that computing in 2019 basically sucks. The problems with 2000-era Linux, as described in the article, are very similar to the problems with 2019-era Linux. External monitors are a particular pain point for me. I've got an HDPI laptop and I want to plug into an old non-HDPI era monitor. Doesn't work. Spend the next 10 hours poking around forums, trying weird XWindows options, installing Wayland, etc. Still doesn't work. Eventually, give up.
Windows 10 works marginally better. Both remain vastly inferior to MacOs.
I'm not saying that the grass isn't greener on the other side. Macs are regressing, but the grass isn't greener on either side. Let's stop pretending otherwise.
nkoren, 3 hours ago
Re: “My Google account got suspended because of NewPip...
If ever there was a clear case for breaking them up, it's this. An issue with Youtube should not impact all other Google services you're using. If they don't like people avoiding Youtube ads, I guess they're free to block their access to Youtube. But don't block access to Android, GMail, Docs and whatever.
mcv, 5 hours ago
If ever there was a clear case for breaking them up, it's this. An issue with Youtube should not impact all other Google services you're using. If they don't like people avoiding Youtube ads, I guess they're free to block their access to Youtube. But don't block access to Android, GMail, Docs and whatever.
mcv, 5 hours ago
Re: Show HN: I've made a rotary dial number input, bec...
Clever - I like it.
But the key thing that made rotary dials usable was the catch at the end - it stopped your finger, so you just pushed until it stopped you, and it registered whichever number your finger was in.
Without that, this version isn't really usable. It needs to lock into a draggable state, then keep rotating so long as the mouse is down, even if you drag outside the control. And then it needs to stop dragging at the end, so you cannot over-drag and pick the wrong number. Do those 2 things, and it would be solid.
codingdave, 19 hours ago
Clever - I like it.
But the key thing that made rotary dials usable was the catch at the end - it stopped your finger, so you just pushed until it stopped you, and it registered whichever number your finger was in.
Without that, this version isn't really usable. It needs to lock into a draggable state, then keep rotating so long as the mouse is down, even if you drag outside the control. And then it needs to stop dragging at the end, so you cannot over-drag and pick the wrong number. Do those 2 things, and it would be solid.
codingdave, 19 hours ago
Re: Uber lays off around 350 more across Eats, self-dr...
This is hardly surprising at all. There used to be lots of complaints, both internally and publicly, about how bloated and ineffective Uber's engineering organization was. Many engineers were bitter about many overlapping projects in Uber. It's also funny that Uber engineers used many bogus reasons to implement NIH projects. A typical example is that Uber had a team to implement their own Bazel-like system because "Bazel (or any other tool) does not scale in Uber-scale". Same went for their own GPU database, their own SQS, their own key-value store, their own resource scheduler, their own datacenter, and their own deployment system. The end result was that almost everything sucked. Engineers suffered productivity loss for years. I kid you not that Uber's docker system didn't support persistent volume for more than three years, so anyone who wanted to build a persistent system like Elasticsearch had to jump hoops and spent weeks even just to get machines. And the sad fact is, Uber did not have a "Uber scale". The traffic and complexity it had to handle was far less than other internet companies.
I wish they didn't hire so irresponsibly back in 2015 and 2016.
hintymad, 2 hours ago
This is hardly surprising at all. There used to be lots of complaints, both internally and publicly, about how bloated and ineffective Uber's engineering organization was. Many engineers were bitter about many overlapping projects in Uber. It's also funny that Uber engineers used many bogus reasons to implement NIH projects. A typical example is that Uber had a team to implement their own Bazel-like system because "Bazel (or any other tool) does not scale in Uber-scale". Same went for their own GPU database, their own SQS, their own key-value store, their own resource scheduler, their own datacenter, and their own deployment system. The end result was that almost everything sucked. Engineers suffered productivity loss for years. I kid you not that Uber's docker system didn't support persistent volume for more than three years, so anyone who wanted to build a persistent system like Elasticsearch had to jump hoops and spent weeks even just to get machines. And the sad fact is, Uber did not have a "Uber scale". The traffic and complexity it had to handle was far less than other internet companies.
I wish they didn't hire so irresponsibly back in 2015 and 2016.
hintymad, 2 hours ago
Re: Uber lays off around 350 more across Eats, self-dr...
I worked at Uber from 2014-2018.
Can confirm this. It was a very poorly managed org because it was extremely grassroots driven—leadership was underempowered to say no to front line teams or hold groups accountable.
The overlaps and poorly considered projects described above are not an exaggeration. Many of them were designed for building the lead engineer's open source brand, not for company needs. Half of the projects described above have since been canceled.
Google:
- Hyperbahn
- Cherami
- Schemaless
- Peloton
- uDeploy
- m3db
- piper
- XYS
Contrary to their glossy open source and tech blog presentations, these projects were highly contentious internally and widely viewed as inferior to industry counterparts. Each of these projects had 5-20 engineers working on them for over a year; many of them are being EOLed or phased out currently. And this is just the list that I can publicly talk about. This development came at extraordinary cost for the org and, in the case of the people who were laid off, cost to people's careers.
mooted1, 6 hours ago
I worked at Uber from 2014-2018.
Can confirm this. It was a very poorly managed org because it was extremely grassroots driven—leadership was underempowered to say no to front line teams or hold groups accountable.
The overlaps and poorly considered projects described above are not an exaggeration. Many of them were designed for building the lead engineer's open source brand, not for company needs. Half of the projects described above have since been canceled.
Google:
- Hyperbahn
- Cherami
- Schemaless
- Peloton
- uDeploy
- m3db
- piper
- XYS
Contrary to their glossy open source and tech blog presentations, these projects were highly contentious internally and widely viewed as inferior to industry counterparts. Each of these projects had 5-20 engineers working on them for over a year; many of them are being EOLed or phased out currently. And this is just the list that I can publicly talk about. This development came at extraordinary cost for the org and, in the case of the people who were laid off, cost to people's careers.
mooted1, 6 hours ago
Re: Superior IQs associated with mental and physical d...
I went through a battery of IQ tests as a kid and got a _high_ score (139). But that was when I was seven years old. I'm 30 now, have a master's degree (which was pretty pointless) and make 25 bucks an hour as a temp (more money than I've ever made in my life). I think my life and prospects have dimmed because I haven't been able to get over the anxiety and the depression that impact me every day. Interviewed for jobs for 14 months and didn't get a single offer. Haven't had a girlfriend in 3 years, lazy as shit, can't even look at myself in the mirror. Anyway, what I'm trying to say is IQ is bullshit, and discipline, social skills, and connections are priceless.
But we grew up in the world told we could do anything we wanted! I think it's that sort of expectation that is screwing with us (at least those of us that didn't become comfy SWEs).
TurkishPoptart, 3 hours ago
I went through a battery of IQ tests as a kid and got a _high_ score (139). But that was when I was seven years old. I'm 30 now, have a master's degree (which was pretty pointless) and make 25 bucks an hour as a temp (more money than I've ever made in my life). I think my life and prospects have dimmed because I haven't been able to get over the anxiety and the depression that impact me every day. Interviewed for jobs for 14 months and didn't get a single offer. Haven't had a girlfriend in 3 years, lazy as shit, can't even look at myself in the mirror. Anyway, what I'm trying to say is IQ is bullshit, and discipline, social skills, and connections are priceless.
But we grew up in the world told we could do anything we wanted! I think it's that sort of expectation that is screwing with us (at least those of us that didn't become comfy SWEs).
TurkishPoptart, 3 hours ago
Re: Superior IQs associated with mental and physical d...
Edit: Joining Mensa is associated with mental and physical disorders.
zxcmx, 5 hours ago
Edit: Joining Mensa is associated with mental and physical disorders.
zxcmx, 5 hours ago
Re: The Unix Game
Not a fan of scratch-like UIs but I figured I'd play around a bit. "Solved" the first problem and went to continue, but was met with a signup wall.
Immediately left with no intention to come back. Things like this absolutely destroy your funnel. Prompt me to sign up after I've made some progress, not before I've even gotten a feel for what you're offering.
reificator, 13 hours ago
Not a fan of scratch-like UIs but I figured I'd play around a bit. "Solved" the first problem and went to continue, but was met with a signup wall.
Immediately left with no intention to come back. Things like this absolutely destroy your funnel. Prompt me to sign up after I've made some progress, not before I've even gotten a feel for what you're offering.
reificator, 13 hours ago
Re: Superior IQs associated with mental and physical d...
Ugh, this study selected its "superior iq" group by surveying Mensa members. Study (https://www.sciencedirect.com/science/article/pii/S0160289616303324#!) makes no mention of this selection bias, though even the article does.
invalidOrTaken, 12 hours ago
Ugh, this study selected its "superior iq" group by surveying Mensa members. Study (https://www.sciencedirect.com/science/article/pii/S0160289616303324#!) makes no mention of this selection bias, though even the article does.
invalidOrTaken, 12 hours ago
Re: Apple: We're not handing over Safari URLs to Tence...
In case you only read the headline, it was confirmed to only happen if the device's region was set to China. From the statement:
> To accomplish this task, Safari receives a list of websites known to be malicious from Google, and for devices with their region code set to mainland China, it receives a list from Tencent.
From Apple's statement, Tencent's API functions exactly the same as Google's k-anonymity model, which you can read more about the api[0] and how it works[1] (also via this JAMIA paper[2]).
0: https://developers.google.com/safe-browsing/v4/update-api#checking-urls
1: https://blog.cloudflare.com/validating-leaked-passwords-with-k-anonymity/
2: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2528029/
judge2020, 12 hours ago
In case you only read the headline, it was confirmed to only happen if the device's region was set to China. From the statement:
> To accomplish this task, Safari receives a list of websites known to be malicious from Google, and for devices with their region code set to mainland China, it receives a list from Tencent.
From Apple's statement, Tencent's API functions exactly the same as Google's k-anonymity model, which you can read more about the api[0] and how it works[1] (also via this JAMIA paper[2]).
0: https://developers.google.com/safe-browsing/v4/update-api#checking-urls
1: https://blog.cloudflare.com/validating-leaked-passwords-with-k-anonymity/
2: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2528029/
judge2020, 12 hours ago
Google for Developers
Safe Browsing Update API (v4) | Safe Browsing APIs (v4) | Google for Developers
Re: How to pack a Norwegian sandwich, the world’s most...
As an Italian, I am profoundly offended by this statement and most of the comments in this thread :D
camillomiller, 11 hours ago
As an Italian, I am profoundly offended by this statement and most of the comments in this thread :D
camillomiller, 11 hours ago
Re: Amazon’s Consumer Business Turned Off Final Oracle...
We've been working on migrating from Oracle to Postgres for a few years now. We are about 2 weeks from being finished. It is not for the faint of heart, but it is totally worth it. The documentation is much much better, performance is equivalent or better, the sql dialect is saner, etc. Other than moving the data itself (ora2pg was invaluable for this), rewriting the queries is what has taken the most amount of time. Some of our tips on differences between oracle and postgres sql:
replace nvl with coalesce
replace rownum <= 1 with LIMIT 1
replace listagg with string_agg
replace recursive hierarchy (start with/connect by/prior) with recursive
replace minus with except
replace SYSDATE with CURRENT_TIMESTAMP
replace trunc(sysdate) with CURRENT_DATE
replace trunc(datelastupdated) with DATE(datelastupduted) or datelastupdated::date
replace artificial date sentinels/fenceposts like to_date(’01 Jan 1900’) with '-infinity'::date
remove dual table references (not needed in postgres)
replace decode with case statements
replace unique with distinct
replace to_number with ::integer
replace mod with % operator
replace merge into with INSERT ... ON CONFLICT… DO UPDATE/NOTHING
change the default of any table using sys_guid() as a default to gen_random_uuid()
oracle pivot and unpivot do not work in postgres - use unnest
ORDER BY NLSSORT(english, 'NLS_SORT=generic_m') becomes ORDER BY gin(insensitive_query(english) gin_trgm_ops)
Oracle: uses IS NULL to check for empty string; in postgres, empty string and null are different
If a varchar/text column has a unique index a check needs to be made to make sure empty strings are changed to nulls before adding or updating the column.
PostgreSQL requires a sub-SELECT surrounded by parentheses, and an alias must be provided for it. - SELECT * FROM ( ) A
any functions in the order by clause must be moved to the select statement (e.g. order by lower(column_name))
Any sort of numeric/integer/bigint/etc. inside of a IN statement must not be a string (including 'null' - don't bother trying to use null="" it won't work). Concatenating a NULL with a NOT NULL will result in a NULL.
Pay attention to any left joins. If a column from a left join is used in a where or select clause it might be null.
For sequences, instead of .nextval use nextval('')
irrational, 1 hour ago
We've been working on migrating from Oracle to Postgres for a few years now. We are about 2 weeks from being finished. It is not for the faint of heart, but it is totally worth it. The documentation is much much better, performance is equivalent or better, the sql dialect is saner, etc. Other than moving the data itself (ora2pg was invaluable for this), rewriting the queries is what has taken the most amount of time. Some of our tips on differences between oracle and postgres sql:
replace nvl with coalesce
replace rownum <= 1 with LIMIT 1
replace listagg with string_agg
replace recursive hierarchy (start with/connect by/prior) with recursive
replace minus with except
replace SYSDATE with CURRENT_TIMESTAMP
replace trunc(sysdate) with CURRENT_DATE
replace trunc(datelastupdated) with DATE(datelastupduted) or datelastupdated::date
replace artificial date sentinels/fenceposts like to_date(’01 Jan 1900’) with '-infinity'::date
remove dual table references (not needed in postgres)
replace decode with case statements
replace unique with distinct
replace to_number with ::integer
replace mod with % operator
replace merge into with INSERT ... ON CONFLICT… DO UPDATE/NOTHING
change the default of any table using sys_guid() as a default to gen_random_uuid()
oracle pivot and unpivot do not work in postgres - use unnest
ORDER BY NLSSORT(english, 'NLS_SORT=generic_m') becomes ORDER BY gin(insensitive_query(english) gin_trgm_ops)
Oracle: uses IS NULL to check for empty string; in postgres, empty string and null are different
If a varchar/text column has a unique index a check needs to be made to make sure empty strings are changed to nulls before adding or updating the column.
PostgreSQL requires a sub-SELECT surrounded by parentheses, and an alias must be provided for it. - SELECT * FROM ( ) A
any functions in the order by clause must be moved to the select statement (e.g. order by lower(column_name))
Any sort of numeric/integer/bigint/etc. inside of a IN statement must not be a string (including 'null' - don't bother trying to use null="" it won't work). Concatenating a NULL with a NOT NULL will result in a NULL.
Pay attention to any left joins. If a column from a left join is used in a where or select clause it might be null.
For sequences, instead of .nextval use nextval('')
irrational, 1 hour ago
Re: YouTube is taking down educational hacking videos
This is the consequence of monopolies. Before YouTube gobbled up the world there were great, niche video sites ran by fans of the coolest things. They are mostly gone now. It is sad. The web really used to be an adventure. I miss that part of the internet. You felt like you found these secret underground worlds where people were really into something. Now it’s different. Maybe what we have now it what is needed for content creators to be fairly compensated, but I will still miss it.
thrwn_frthr_awy, 21 hours ago
This is the consequence of monopolies. Before YouTube gobbled up the world there were great, niche video sites ran by fans of the coolest things. They are mostly gone now. It is sad. The web really used to be an adventure. I miss that part of the internet. You felt like you found these secret underground worlds where people were really into something. Now it’s different. Maybe what we have now it what is needed for content creators to be fairly compensated, but I will still miss it.
thrwn_frthr_awy, 21 hours ago
Re: Why Switzerland is better than Silicon Valley for ...
Bullshit alertThey start with: "Maybe it is because of the outrageous rents eating over 30% of the salary and houses you cannot afford unless you joined Facebook or Google at the right time? " Regarding the SV.
Then, this is what they (proudly) say about Switzerland: 1) "In Zurich, you can rent a whole flat (50+ square meters) for something between 2500-4000 CHF " 2) "In Switzerland a Software Developer can easily earn over 100,000 CHF (1 CHF is around 1 USD) "
So, that means that we can calculate your rent there to be between 30% to 48%. But I guess, just because it is in Switzerland, it should not be outrageous?
greatgib, 3 hours ago
Bullshit alertThey start with: "Maybe it is because of the outrageous rents eating over 30% of the salary and houses you cannot afford unless you joined Facebook or Google at the right time? " Regarding the SV.
Then, this is what they (proudly) say about Switzerland: 1) "In Zurich, you can rent a whole flat (50+ square meters) for something between 2500-4000 CHF " 2) "In Switzerland a Software Developer can easily earn over 100,000 CHF (1 CHF is around 1 USD) "
So, that means that we can calculate your rent there to be between 30% to 48%. But I guess, just because it is in Switzerland, it should not be outrageous?
greatgib, 3 hours ago
Re: “My Google account got suspended because of NewPip...
I think these automatic suspensions are really alarming.
I got my whole Vimeo account suspended by some script that had the impression I was violating some of their ToS. I just uploaded 3 demo videos of an app I created. Then they told me I should click on a link to contact support, where they told me I have to log in to contact support, which I couldn't do because my account was shut down.
I just released a blog article that needed these videos, so I didn't have any time for these things so I quickly uploaded the videos to Youtube.
I mean that was just a small account with three videos, but they simply nuked the whole thing. That's just crazy.
I don't think I'm save at Youtube either, I just didn't have a better idea at the time.
k__, 1 day ago
I think these automatic suspensions are really alarming.
I got my whole Vimeo account suspended by some script that had the impression I was violating some of their ToS. I just uploaded 3 demo videos of an app I created. Then they told me I should click on a link to contact support, where they told me I have to log in to contact support, which I couldn't do because my account was shut down.
I just released a blog article that needed these videos, so I didn't have any time for these things so I quickly uploaded the videos to Youtube.
I mean that was just a small account with three videos, but they simply nuked the whole thing. That's just crazy.
I don't think I'm save at Youtube either, I just didn't have a better idea at the time.
k__, 1 day ago