Post #2236146
2025-08-08 07:03 UTC
Replies (37)
-
@echopapa@social.tchncs.de 2025-08-08 07:36
@jpmens@mastodon.social Thanks. Never looked at that page. Modifying .zip files by sqlite is quite funny :-)
-
@phil@social.kern.pm 2025-08-08 07:43
@jpmens@mastodon.social So can I query a SQLite database from the result of a bytes lookup of another query? E.g. a file stored in a ZIP? 🙃
-
@goetz@freiburg.social 2025-08-08 07:43
@jpmens@mastodon.social @gereon@chaos.social This is because of UNIX, where everything is a file (check?: ☑️) and tools can do 1 thing and that very well (chec… eehhhh? …).
-
@jamesog@mastodon.social 2025-08-08 10:49
@jpmens@mastodon.social And here's me thinking this kind of magic was reserved for the likes of duckdb
-
@msk@mastodon.gamedev.place 2025-08-08 12:17
@jpmens@mastodon.social amazing! but... why?
-
@JustinDerrick@mstdn.ca 2025-08-08 13:41
@jpmens@mastodon.social Fascinating, yet... mystifying... #WTF
-
@morebento@aus.social 2025-08-08 14:20
@jpmens@mastodon.social amazing 🙌
-
@mdsumner@rstats.me 2025-08-08 14:30
@jpmens@mastodon.social wild, certainly the old db server bs had to die a lot earlier than it did
-
@follpvosten@karp.lol 2025-08-08 16:25
@jpmens@mastodon.social oh my god.
-
@fraggle@social.coop 2025-08-09 00:25
@jpmens@mastodon.social it's refreshingly simple to make these kinds of extensions to sqlite. I created one for Doom dehacked patches for example https://github.com/fragglet/deh9000/blob/trunk/deh9000/sqlite.py
-
@Viss@mastodon.social 2025-08-09 05:08
@jpmens@mastodon.social a new exfil technique has appeared :D
-
@magnetic_tape@infosec.exchange 2025-08-09 07:17
@jpmens@mastodon.social #TIL of this SQLite functionnality
-
@f4grx@chaos.social 2025-08-09 07:35
@jpmens@mastodon.social and did you know that it was coded by a group of christian bigots that do not accept external contributions?
-
@wyliecoyoteuk@mastodon.org.uk 2025-08-09 08:00
@jpmens@mastodon.social The secrets hidden in the docs are many and arcane. Why do you think manufacturers print them in tiny weird fonts in pale grey on a pink background or similar ? They really don't want you to read them. Especially the Chinese ones.
-
@ellie@ellieayla.net 2025-08-09 08:18
@jpmens@mastodon.social what??
-
@realn2s@infosec.exchange 2025-08-09 08:23
@jpmens@mastodon.social 😳 TILT (today I learned too) Actually pretty cool
-
@ma1@todon.eu 2025-08-09 09:52
@jpmens@mastodon.social RTFM Is not cursing, it's a blessing from ancient wisdom.
-
@cvtsi2sd@hachyderm.io 2025-08-09 09:56
@jpmens@mastodon.social https://sqlite.org/zipfile.html apparently you can use it even from inside applications if you compile SQLite just right
-
@aliceice@social.aliceice.de 2025-08-09 10:18
@jpmens@mastodon.social Wait what?! That's a crazy, fantastic find! 😁
-
@rlcw@ecoevo.social 2025-08-09 10:35
@jpmens@mastodon.social I recently used SQLite in an app, and man has that saved me a world of headache, because I didn't have to worry about setting up a database. But I didn't know about the zip archives jet
-
@kura@hai.z0ne.social 2025-08-09 11:16
@jpmens@mastodon.social That is cursed. Very cursed....
-
@Samuelrod@mastodon.social 2025-08-09 11:25
@jpmens@mastodon.social great
-
@ozone89@techhub.social 2025-08-09 12:08
@jpmens@mastodon.social sooo... Does it mean any app on the Play Store using SQLite3 is now to be removed?
-
@itnomad@ruhr.social 2025-08-09 12:29
@jpmens@mastodon.social Cursed!
-
@foobarblubb@ohai.social 2025-08-09 12:55
@jpmens@mastodon.social sqlite's documentation is generally very well written, informative and factual but with a dry humour when fitting. The section Maximum Database Size on https://sqlite.org/limits.html includes the gem: "This particular upper bound is untested since the developers do not have access to hardware capable of reaching this limit."
-
@rstub@digitalcourage.social 2025-08-09 13:10
@jpmens@mastodon.social TIL!
-
@djoerd@idf.social 2025-08-09 13:32
@jpmens@mastodon.social Did you know @duckdb@mastodon.social supports gzip, zstd, lz4, snappy, and brotli compression transparently based on the file extension, containing csv, json, excel, parquet, sqlite, postgresql, and more? 🤯 https://duckdb.org/docs/stable/guides/file_formats/overview.html
-
@da_habakuk@fosstodon.org 2025-08-09 13:52
@jpmens@mastodon.social @nixCraft@mastodon.social but why? :)
-
@KaiserOfNone@vmst.io 2025-08-09 13:59
@jpmens@mastodon.social I kind of love this
-
@jskeletti@det.social 2025-08-09 14:10
@jpmens@mastodon.social What the hack. Pretty nice!
-
@ltning@pleroma.anduin.net 2025-08-09 14:10
@jpmens@mastodon.social beats having to `man unzip` every time
-
@dalius_berger@plush.city 2025-08-09 14:35
@jpmens@mastodon.social it's a module, the cli implementation comes with it. But it's possible that it wont be there when using other APIs for interacting with sqlite DBs. https://sqlite.org/zipfile.html
-
@mikeTesteLinuxQlub@qlub.social 2025-08-09 15:41
@jpmens@mastodon.social Holy moly, that little thing is powerfull 😂
-
@druid@toot.wales 2025-08-09 15:55
@jpmens@mastodon.social I didn't know that!
-
@seeteegee@social.afront.org 2025-08-09 16:03
@jpmens@mastodon.social just imagine if we could mount a zip as a filesystem.
-
@bee8bit@social.cologne 2025-08-12 16:04
@jpmens@mastodon.social Not the same thing but I think you might like nushell. https://www.nushell.sh/
-
@inetpro@infosec.exchange 2025-08-18 19:06
@jpmens@mastodon.social wow, that is cool!