4 ms·

SQLite 4.0 Release Notes: https://sw.vtom.net/hn35/pages/90098234.html https://sw.vtom.net/hn35/pages/90098234.html Another absolute gem: Columns now supp

SQLite 4.0 Release Notes: https://sw.vtom.net/hn35/pages/90098234.html https://sw.vtom.net/hn35/pages/90098234.html Another absolute gem: Columns now support "Vibe" affinity. If the data feels like an integer, it is stored as an integer. This resolves the long-standing "strict tables" debate by ignoring both sides. Also: SQLite 4.0 is now the default bootloader for 60% of consumer electronics. The build artifacts include sqlite3.wasm which can now run bare-metal without an operating system. edit: added link

ray_v 10mo ago
I may live to see it; peak sqlite.
- teiferer 10mo ago
  You are laughing. IBM has already been there, with DB2 having essentially been the OS on mainframes a few decades ago.
  - TeMPOraL 10mo ago
    All of this has happened before. All of this will happen again.
    - ray_v 10mo ago
      So it's true, the profits have spoken of this!
patates 10mo ago
I haven't laughed this much for a while :) I'm exploring the possibility for gemini to write me such jokes every day when I wake up - perhaps it can vibe code something itself.
menaerus 10mo ago
And It is now the only software in the world still written in C89. Hilarious.
- throwaway2037 10mo ago
  But wait, there's more! > Predictive SELECT Statements: > Added the PRECOGNITION keyword. > SELECT * FROM sales WHERE date = 'tomorrow' now returns data with 99.4% accuracy by leveraging the built-in 4kB inference engine. The library size has increased by 12 bytes to accommodate this feature. 12 bytes really sounds like something that the lead dev would write!
xp84 10mo ago
Omg the Bloomberg/IBM article has so many Easter eggs
- throwaway2037 10mo ago
  Here is the link: https://sw.vtom.net/hn35/pages/90097654.html https://sw.vtom.net/hn35/pages/90097654.html The content spot on and very funny. Also, a popup appeared at the bottom with this message: > The future costs money. > You have reached your free article limit for this microsecond. > Subscribe for 0.0004 BTC/month Suddenly, I have high hopes again for LLMs. Imagine you were a TV/film script writer and had writer's block. You could talk to an LLM for a while to see what funny ideas it can suggest. It is one more tool in the arsenal.
locknitpicker 10mo ago
> This resolves the long-standing "strict tables" debate by ignoring both sides. This is brilliant. Well done.

ray_v 10mo ago

I may live to see it; peak sqlite.

teiferer 10mo ago
You are laughing. IBM has already been there, with DB2 having essentially been the OS on mainframes a few decades ago.
- TeMPOraL 10mo ago
  All of this has happened before. All of this will happen again.
  - ray_v 10mo ago
    So it's true, the profits have spoken of this!

patates 10mo ago

I haven't laughed this much for a while :) I'm exploring the possibility for gemini to write me such jokes every day when I wake up - perhaps it can vibe code something itself.

menaerus 10mo ago

And It is now the only software in the world still written in C89. Hilarious.

throwaway2037 10mo ago
But wait, there's more! > Predictive SELECT Statements: > Added the PRECOGNITION keyword. > SELECT * FROM sales WHERE date = 'tomorrow' now returns data with 99.4% accuracy by leveraging the built-in 4kB inference engine. The library size has increased by 12 bytes to accommodate this feature. 12 bytes really sounds like something that the lead dev would write!

xp84 10mo ago

Omg the Bloomberg/IBM article has so many Easter eggs

throwaway2037 10mo ago
Here is the link: https://sw.vtom.net/hn35/pages/90097654.html https://sw.vtom.net/hn35/pages/90097654.html The content spot on and very funny. Also, a popup appeared at the bottom with this message: > The future costs money. > You have reached your free article limit for this microsecond. > Subscribe for 0.0004 BTC/month Suddenly, I have high hopes again for LLMs. Imagine you were a TV/film script writer and had writer's block. You could talk to an LLM for a while to see what funny ideas it can suggest. It is one more tool in the arsenal.

locknitpicker 10mo ago

> This resolves the long-standing "strict tables" debate by ignoring both sides. This is brilliant. Well done.