First post on public network created using minimitra:
All identifiers are ap URIs, so only FEP-ef61 implementers can load this post and interact with it.
@silverpill cool! what about #SQLite database for the desktop app?
Claudius Link
boosted
Discovering the visionary #moodlebox project made me think that the #moodle project has really missed a trick by not properly supporting #sqlite as a database backend.
It would make tinkering with and hacking on the codebase so much easier, potentially expanding #opensource contributor numbers but also generating possible new use cases.
Discovering the visionary #moodlebox project made me think that the #moodle project has really missed a trick by not properly supporting #sqlite as a database backend.
It would make tinkering with and hacking on the codebase so much easier, potentially expanding #opensource contributor numbers but also generating possible new use cases.
🦀 Deep dive into Turso, the "SQLite rewrite in Rust" // Sylvain Kerkour
Michael Dexter
and 1 other
boosted
#SQLite #Rust
Visiblement quelqu'un a ré-écrit SQLite en Rust : https://github.com/tursodatabase/turso
Je ne sais pas si c'est une bonne idée.🤔
https://kerkour.com/turso-sqlite
EDIT: Oh merde, je n'avais pas fait gaffe au ".claude" 😬 ça a probablement été vibe-codé.
Here's a repo we just released that builds the `spellfix` plugin for the OS-distro version of #SQLite on #macOS, #iOS, and iOS-Simulator aarch64.
The version of SQLite that ships on macOS and iOS is pretty stripped down, to make it small. We've needed to use some extensions and getting them to compile and work with the off-the-shelf SQLite is not trivial. I previously evolved another plugin and made nice Makefile support for this. `spellfix` is much easier to handle.
Turso is an in-process SQL database, compatible with SQLite
https://github.com/tursodatabase/turso
#HackerNews #Turso #SQL #Database #SQLite #InProcess #Database #TechNews
The next-gen SQLite won't look like SQLite
https://gist.github.com/radarroark/03a0724484e1111ef4c05d72a935c42c
#HackerNews #nextgenSQLite #SQLite #evolution #database #technology #innovation
TIL that #SQLite doesn't allow union queries when there's a limit applied. That stinks.
Travis F W
boosted
I downloaded my Reddit history archive. It has a giant list of every comment I've ever made, as a CSV file.
I wanted to look at each comment, in context, on #Reddit. (To do that you need to open the URL in your browser with ?context=9 appended to the URL.)
At first, I loaded this behemoth into LibreOffice Calc, but it does not like data that big.
Then I was like, “hey wait, this is basically a database.” So I loaded it into SQLite.
#SQLite has absolutely no problem with data that big. 😌
I downloaded my Reddit history archive. It has a giant list of every comment I've ever made, as a CSV file.
I wanted to look at each comment, in context, on #Reddit. (To do that you need to open the URL in your browser with ?context=9 appended to the URL.)
At first, I loaded this behemoth into LibreOffice Calc, but it does not like data that big.
Then I was like, “hey wait, this is basically a database.” So I loaded it into SQLite.
#SQLite has absolutely no problem with data that big. 😌
22 GB of hacker news in SQLite
https://hackerbook.dosaygo.com
#HackerNews #HackerNews #SQLite #DataAnalysis #DataStorage #TechNews #22GBInsights
Chip Butty
boosted
just updated litehug to include examples for using it from #lua for #sqlite queries
https://git.sr.ht/~technomancy/litehug
not that you couldn't before, but now it's a lot more obvious how it works... feedback welcome!
just updated litehug to include examples for using it from #lua for #sqlite queries
https://git.sr.ht/~technomancy/litehug
not that you couldn't before, but now it's a lot more obvious how it works... feedback welcome!