 |
Post AwzuyikcCD9t5kaRDE by [email protected] |
 |
More posts by [email protected] |
|
Post #Awx6fTEKIGwLQdBvGa by [email protected] |
|
0 likes, 4 repeats |
|
|
|
The things I learn, even at my age, simply by reading documentation are WILD! T… |
|
|
|
Post #Awx9csAxODh5n24ICm by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens Thanks. Never looked at that page. Modifying .zip files by sqiite is qu… |
|
|
|
Post #AwxBQhj2cLQRoQKuNE by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens So can I query a SQLite database from the result of a bytes lookup of a… |
|
|
|
Post #AwxBQhpQEcWu8DK0Js by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@phil 10 GOTO 10 |
|
|
|
Post #AwxGhaoo3BKl5HuBcm by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens @gereon This is because of UNIX, where everything is a file (check?: ๏ฟฝ… |
|
|
|
Post #AwxGhawFbVHxSNO8EC by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@goetz @jpmens @gereon "Every program attempts to expand until it can read… |
|
|
|
Post #AwxGwSp23xLocz6Nyy by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@goetz @jpmens @gereon I appreciate the joke, but I find it quite enlightening,… |
|
|
|
Post #AwxXwSW2tqnktmnwxs by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@giuseppe_aceto @jpmens @gereon You can see a ZIP file as a (very special, or b… |
|
|
|
Post #AwxXwScQW7uDDZn2uW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@goetz @jpmens @gereon no need to change your mind: I agree. Somebody else chan… |
|
|
|
Post #AwxYA8HUvd20CEWJ1M by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens And here's me thinking this kind of magic was reserved for the like… |
|
|
|
Post #AwxYmRtuQpwM37l17o by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@echopapa @jpmens This could even get better if the files in the ZIP are JSON, … |
|
|
|
Post #AwzIBNhjrQpLMzHsem by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@jpmens ๐ณ TILT (today I learned too)Actually pretty cool |
|
|
|
Post #AwzIXH53AYmPCFd9tI by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens amazing! but... why? |
|
|
|
Post #AwzIXHC8kCS1YEwowS by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@msk @jpmens Wild guess (without research or deep knowledge) sqlite uses zip in… |
|
|
|
Post #Awzm07WEhA0qbvSBFY by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@jpmens I kind of love this |
|
|
|
Post #AwzmyI1Om9EyYiijg0 by ltning |
|
0 likes, 0 repeats |
|
|
|
@jpmens beats having to `man unzip` every time |
|
|
|
Post #Awztc5o4D3FBz0qbcu by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens it's refreshingly simple to make these kinds of extensions to sqlit… |
|
|
|
Post #AwztkAu58uk06kVz3g by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens https://sqlite.org/zipfile.html apparently you can use it even from ins… |
|
|
|
Post #AwztkgEMfYNvGdF7Tc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens @nixCraft but why? :) |
|
|
|
Post #AwztlkRQV236cFrU00 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens oh my god. |
|
|
|
Post #AwztnWRZVtWdmYm9Uu by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmensI recently used SQLite in an app, and man has that saved me a world of h… |
|
|
|
Post #Awztqb2gs86yuhbTjU by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens and did you know that it was coded by a group of christian bigots that … |
|
|
|
Post #Awztqb9mRlmbGgv8me by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@f4grx would you have preferred muslim bigots? |
|
|
|
Post #AwztqbFo5MbTZNjxB2 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens I would have preferred no bigots at all. All religions are equally bad … |
|
|
|
Post #AwztqbKlmuZbom3uue by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@f4grx I don't think anybody forces you to use their software. Your comment… |
|
|
|
Post #Awztrx8yBZ2tkVBgBM by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens Wait what?! That's a crazy, fantastic find! ๐ |
|
|
|
Post #AwztyAJE9L0kJnwo7c by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens sooo... Does it mean any app on the Play Store using SQLite3 is now to … |
|
|
|
Post #Awzu1xJiOc2BBMz10a by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens what?? |
|
|
|
Post #Awzu6858JZGNj99Wjo by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens a new exfil technique has appeared :D |
|
|
|
Post #Awzu6H42uyk1aNiHnE by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens TIL! |
|
|
|
Post #Awzu9IP6OThEbq0F4i by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens @f4grx Nah, it was relevant cultural context |
|
|
|
Post #Awzu9IVpzR5Gwj9cZc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@soatok @f4grx completely irrelevant to my post, and addressing that at me is w… |
|
|
|
Post #Awzu9IcDbiBjGW8iWG by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens @f4grx It's relevant cultural context any time sqlite is mentioned,… |
|
|
|
Post #Awzu9Y6tzue3K1bvvc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens What the hack. Pretty nice! |
|
|
|
Post #AwzuDTcAed2kXN6pu4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens Fascinating, yet... mystifying...#WTF |
|
|
|
Post #AwzuGwbvIvavKreAro by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens it's a module, the cli implementation comes with it. But it's … |
|
|
|
Post #AwzuL7nDffWXAtvLvs by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens sqlite's documentation is generally very well written, informative … |
|
|
|
Post #AwzuRFlwusITf0Fhi4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens wild, certainly the old db server bs had to die a lot earlier than it d… |
|
|
|
Post #Awzubez22N0ekMKl9M by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@peterainbow @echopapa @jpmens If you just open other peoples files. But that i… |
|
|
|
Post #AwzueWIemKsUgTsQoS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens Did you know @duckdb supports gzip, zstd, lz4, snappy, and brotli compr… |
|
|
|
Post #AwzuhTpcPcynthhq64 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens#TIL of this SQLite functionnality |
|
|
|
Post #AwzuoUjdS3fAj7FhfE by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens RTFM Is not cursing, it's a blessing from ancient wisdom. |
|
|
|
Post #AwzupCuTD8TRjSeyf2 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@msk because one can. ๐@jpmens |
|
|
|
Post #AwzupKPDLEE2yq683M by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmensCursed! |
|
|
|
Post #AwzuvtYrXwm9kck568 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens The secrets hidden in the docs are many and arcane.Why do you think man… |
|
|
|
Post #AwzuyikcCD9t5kaRDE by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens amazing ๐ |
|
|
|
Post #AwzuzVcqTt3gfqKQPA by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens great |
|
|
|
Post #Awzz4WUl4iWwdSByCW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens I didn't know that! |
|
|
|
Post #Awzz6vZsn0A90UjfNI by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens just imagine if we could mount a zip as a filesystem. |
|
|
|
Post #AwzzDWVQP8cLH6nNi4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jpmens Holy moly, that little thing is powerfull ๐ |
|
|
|
Post #Ax0CYTuJvUPwTADBc8 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@realn2s @jpmens that would be an excellent why |
|
|
|
Post #Ax0CdVT9Xy4SlFttaK by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@giuseppe_aceto @goetz @jpmens @gereon Not Unix (not that it matters)OS/400 can… |
|
|
|
Post #Ax0Ckehfc3uFQZ6FDU by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@soatok @f4grx ๐ฏCalling out bigots is always right ๐ช |
|
|
|
Post #Ax0CobuZw0o3vY1Vqq by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@seeteegee @jpmens checkout FUSE. It is also magic. |
|
|
|
Post #AxIs9M1OSZMek0SxBA by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@jpmens wow, that is cool! |
