Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
ttfkam
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
18 ms
·
241.
▲
by
ttfkam
3y ago
Good?
242.
▲
by
ttfkam
3y ago
No. Rose-colored glasses. Back when software was purchased in shrink wrap, quality was definitely a crap shoot. It was normal to reboot your DOS machine because the memory hack you used for one program didn't work for another (himem.sy
243.
▲
by
ttfkam
3y ago
Bitcoin and other crypto get big enough, regulation will follow shortly after. That said, the first to flee regulation in the financial sector are much more heavily weighted toward the grifters and fraudsters. See: Mt. Gox People flocked to
244.
▲
by
ttfkam
3y ago
> the obvious answer is people need to stop giving all their money to 1 institution that they can't assess the creditworthiness of. You literally just described everyone who has a bank account. The finance sector is anything but tra
245.
▲
by
ttfkam
3y ago
Oh yeah, and Bitcoin mining alone is 2% of all electricity consumption in the US. Nonsense. Absolute insanity. The definition of wasted resources. Those are all EV vehicle charging numbers. https://arstechnica.com/science&#x
246.
▲
by
ttfkam
3y ago
Previous generations learned the hard way that when you lose your life savings, once is too often. A lot of folks never recovered after the first time it happened to them. Identifying a huckster isn't as easy as you say. A lot of folks
247.
▲
by
ttfkam
3y ago
Redshift: columnar database with a Postgres query interface.
248.
▲
by
ttfkam
3y ago
Hard to test?
249.
▲
by
ttfkam
3y ago
I love Postgres and relational databases in general, but the lack of documentation generation found in general purpose programming languages for the last 20 years is a glaring omission. There simply are no good equivalent to Javadoc for SQL
250.
▲
by
ttfkam
3y ago
If you don't write your database layer with vendor-specific features and optimizations in mind, you're definitely leaving tons of performance on the floor. Multi-DB support for a largely identical schema is a fool's errand. I
251.
▲
by
ttfkam
3y ago
You lost me at ORM. Once an ORM is in play, you're in integration test territory in my opinion, not unit test.
252.
▲
by
ttfkam
3y ago
pl/pgSQL is very good (and ergonomic) for a logical extension to SQL, aka set theory programming with intermediate state. It isn't and was never targeted toward general purpose programming like Python. That said, 100% agree that u
253.
▲
by
ttfkam
3y ago
Had the opposite experience. Row-level policies had minimal overhead (<5%?) but improved security at the app layer tremendously. It was intensely satisfying to have cases where UI developers were complaining that data was missing. Turned
254.
▲
by
ttfkam
3y ago
A data store *that enforces valid data at all times*. Far too many people miss that part. They skimp on foreign keys, check constraints, and the most appropriate data types. Time is far better spent getting the schema right at the outset th
255.
▲
by
ttfkam
3y ago
In the wake of the 1929 crash and The Great Depression, a huge swath of regulations were put onto financial institutions so as to limit the riskiest investments with money in personal savings and checking accounts, aka Glass-Steagall. FDIC
256.
▲
by
ttfkam
3y ago
Good write up. As I've written my own temporal table library for Postgres that also runs on managed databases like AWS Aurora, here are my observations: If you main table inherits from a history table, you can see a complete history of
257.
▲
by
ttfkam
3y ago
SvelteKit supports SPA, MPA, and fluid hydration through either server-side or client-side generation in the same app as needed. Testing only its SPA mode seems a bit biased.
258.
▲
MySQL Silently Ignores Foreign Keys
(dev.mysql.com)
1 points
by
ttfkam
3y ago
|
1 comments
259.
▲
by
ttfkam
3y ago
When porting your database schema from other engines, it is common to have REFERENCES clauses inline with the column. MySQL parses the syntax but does not actually create the foreign key constraints. Worse still, it does so silently, withou
260.
▲
by
ttfkam
3y ago
There are definitely omitted parts to this story. We get it. Everyone does it. But this is definitely not the whole story.
261.
▲
by
ttfkam
3y ago
So own an EV and rent the SUV, camper, hybrid, whatever once or twice a year. Normal and predictable events can get good discounts with advance reservation. Obviously if the trips are more frequent, eg. monthly, the economics will shift tow
262.
▲
by
ttfkam
3y ago
I disagree. The sustainable alternative is to get an EV for 98% of the time and rent a purpose-built vehicle for the edge cases whether those edge cases are for long distance, towing, or hauling. Let the rental companies keep and maintain t
263.
▲
MySQL Adds JavaScript Support
(blogs.oracle.com)
3 points
by
ttfkam
3y ago
|
1 comments
264.
▲
by
ttfkam
3y ago
Only available for enterprise customers so far, custom functions in JavaScript via GraalVM provide ahead-of-time compilation for the newly added language. Plv8 for PostgreSQL provides comparable functionality as the two database engines con
265.
▲
First Production Lithium-Free EV
(engadget.com)
1 points
by
ttfkam
3y ago
|
0 comments
266.
▲
by
ttfkam
3y ago
You are making the assumption that Tesla will survive. A lot of things can happen in the next 85 years.
267.
▲
by
ttfkam
3y ago
Not a Xmas movie, but 100% a New Year's Eve movie! https://templeofgeek.com/bring-new-year-classic-films/
268.
▲
by
ttfkam
3y ago
More than 100 years? Are you SURE about that?
269.
▲
by
ttfkam
3y ago
I think you're assuming a city bus needs a fare. It doesn't. Santa Cruz County, CA has just passed a resolution where all busses in the county will be free to ride. It already is for folks working downtown, anyone under 18, anyone
270.
▲
by
ttfkam
3y ago
One major gripe I have with driving in California is no clear traffic law requiring folks to move over when getting passed on the right. It's not the speed. It's the speed difference as cars end up weaving between lanes in traffic
More ›