ttfkam

99 ms·

961.
by ttfkam 4y ago
Because it's very easy to get things wrong or cause foot guns for the user. The Postgres core team tends to err on the side of delay (or outright rejection) rather than release a feature that could lead to data loss. https:/&#x2F
962.
by ttfkam 4y ago
I used to work for Google and have yet to see Java compile faster than Go.
963.
by ttfkam 4y ago
Obviously not fast enough for Google since they literally invented a new programming language (Go) to address the compile time and runtime limitations of Java.
964.
by ttfkam 4y ago
100% agree. And the Rust compiler is a great way to internalize those lessons since it shows what you got wrong, where you missed an ownership assignment, and often telling you how to fix the problem in plain English. It's as close as
965.
by ttfkam 4y ago
What happens if someone deletes a tenant?
966.
by ttfkam 4y ago
"There are two novels that can change a bookish fourteen-year old’s life: The Lord of the Rings and Atlas Shrugged. One is a childish fantasy that often engenders a lifelong obsession with its unbelievable heroes, leading to an emotion
967.
by ttfkam 4y ago
No one except the President of the United States for the better part of a year in front of a large number of microphones, transmitted to millions of screens. Memories are short. https://youtu.be/TgZAazfHo7k Approximate US d
968.
by ttfkam 4y ago
Are you suggesting that Chinese cities have been under continuous lockdown for the last two years? Because that's not the case. Wuhan for example began its lockdown in Feb 2020 and ended it Apr 2020. There was a brief, limited lockdown
969.
by ttfkam 4y ago
Java 1.1: Event listeners. No more bubbling!
970.
by ttfkam 4y ago
Yes. I am fully aware only an authoritarian government would be willing and able to forcibly lock down entire cities. BUT It stopped the spread in its tracks unlike the US and Europe who kept spreading for a year and a half. After a few mon
971.
by ttfkam 4y ago
Shanghai is like the Florida of China. Most of the rest of China had fully opened up long ago without any restrictions due to a zero Covid policy that worked. Shanghai always cut corners and kept getting hit with new outbreaks the rest of t
972.
by ttfkam 4y ago
That would open up some non-trivial DoS attack vectors as things currently stand. Who would own the new partition? If all records for the company were removed, does the partition get deleted or remain empty? What happens if some performs a
973.
by ttfkam 4y ago
It's almost like the UK and the US use different terms for the same thing. ;-) Apparently short-sightedness of both varieties is on the rise.
974.
by ttfkam 4y ago
You already can. PARTITION BY LIST. CREATE TABLE … PARTITION OF … FOR VALUES IN ('the_customer'); https://www.postgresql.org/docs/current/ddl-partitioning.htm...
975.
by ttfkam 4y ago
Honestly, once I learned about client-side image maps, I don't think I ever even thought to touch the form-based ones ever again.
976.
by ttfkam 4y ago
Ah, CSS expressions. So many memories of making IE6/7 polyfills in 2011. Without CSS expressions and behaviors, wonderful tools like CSS3PIE would never have been possible. https://github.com/lojjic/PIE As painful
977.
by ttfkam 4y ago
And then there are projects like CDK-Dia that are taking infra documentation one step further. https://github.com/pistazie/cdk-dia
978.
by ttfkam 4y ago
Look up the prices of used Nissan Leafs. For modern cars, quite affordable. I see a 2012 for $9K and a 2017 for $18K. Even if you had to buy a new $4K battery for the 2012, it'd still be $13K electric car with a new battery.
979.
by ttfkam 4y ago
A 40% reduction would be 600GB, and an index that took up 40% of the total would be excessive/unrealistic as well. You're right of course that Postgres lacks true clustered indexes. The closest thing it has is covering indexes, wh
980.
by ttfkam 4y ago
The key to temporal tables in Postgres is the following: • add a timestamp range column • create a history table that matches the main table • using table inheritance, have the live table inherit from the history table At this point all que
981.
by ttfkam 4y ago
Just make a function with the table name as a parameter. Same effect as what you're looking for except not included in SELECT *. eg. SELECT col1, col2, col3(t) FROM table_name t; This is how Postgraphile solved the problem to great eff
982.
by ttfkam 4y ago
True, but you can simulate it by running the query with the window function in a CTE and then make a separate SELECT with the appropriate WHERE clause. More verbose, but the same effect and result. Using NOT MATERIALIZED on the CTE can also
983.
by ttfkam 4y ago
I believe what you're looking for is (in PostgreSQL) called a set returning function.
984.
by ttfkam 4y ago
Materialized views + pg_cron = chef's kiss for simple yet performant report generation.
985.
by ttfkam 4y ago
One of the biggest eye-openers for me was this chart. https://www.sql-workbench.eu/dbms_comparison.html One day I just sat down and learned about every item on that table. Not memorizing, just learning what it was for. Not
986.
by ttfkam 4y ago
https://madlib.apache.org/ https://docs.timescale.com/timescaledb/latest/how-to-guides/... https://duckdb.org/2022/05/04/friendlier-sql.html It's a shame
987.
by ttfkam 4y ago
Wholeheartedly agree about the need for better and bidirectional tools. That said, while I appreciate MySQLWorkbench and its ERD generation skills, I have never seen anything sufficiently powerful to document the features in a more feature-
988.
by ttfkam 4y ago
Seconded! You can have my PlantUML when you pry it from my cold, dead hands. Once I was shown diagram source you can diff between revisions, I was sold.
989.
by ttfkam 4y ago
Re-read my comment. I was not talking about app performance, though Svelte is indeed lighter and faster for various reasons. I made the analogy to assembly vs C. It's not about raw speed. Many APIs and (frankly) hacks have been added
990.
by ttfkam 4y ago
I think you've missed something fundamental. Imagine you're using a spreadsheet app. You put data into a column. Then in another column you write a formula referencing the first column. Then you write a sum formula to put it all t

More ›