Re: [sqlite] How should I use the sqlite3 tool?(for linux)

On Tue Mar 03, 2020 at 05:12:17PM +0800, suanzi wrote: > Thank you,you let me know what happened. > > About your answer,I try it,but it can't work,maybe because can't have two > zlib. > > apt-get could not find zlib:i386. Did you specifically try "zlib1g"? I don't think the "zlib" package

[sqlite] Updates to althttpd.c for LetsEncrypt compatibility

TL;DR: If you are using althttpd.c on your website, you will need to get the latest code and recompile before the next time you need to get a cert from LetsEncrypt. There are no (known) vulnerabilities or problems with althttpd.c. This is merely an update for LetsEncrypt compatibility due to

[sqlite] FaceBook reduced Messenger size partly through increased use of SQLite

FaceBook significantly reduced the size of its Messenger app partly by relying on SQLite to do more of the heavy lifting: "Project LightSpeed: How Facebook shrunk Messenger down by 75%" https://www.fastcompany.com/90470219/project-lightspeed-how-facebook-shrunk-messenger-down-by-75 "With

Re: [sqlite] How to enforce a specific order of group_concat?

On Mon, Mar 2, 2020 at 6:35 PM Keith Medcalf wrote: > Well, in theory an order by in a nested select means that the result of the > operation is an ordered projection and not merely a set of rows. > For this particular case (a nested select with an order by and the outer > query with an

Re: [sqlite] How should I use the sqlite3 tool?(for linux)

Thank you,you let me know what happened. About your answer,I try it,but it can't work,maybe because can't have two zlib. apt-get could not find zlib:i386. And there have not sqlite3 tool for linux x64 in sqlite.org Anyway,thank you,I plan download the sqlite source and compile.

Re: [sqlite] How should I use the sqlite3 tool?(for linux)

This means you're missing a dependency - in this case zlib. It's hard to believe you don't have zlib on your system at all; probably this is happening because your system is amd64 but the sqlite binary you've downloaded is x86. I'm not a debian user but this should get you going: apt-get install

Re: [sqlite] How should I use the sqlite3 tool?(for linux)

My OS is Debian10 amd64,desktop is xfce4 ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How should I use the sqlite3 tool?(for linux)

After I download the tool,I cd to the path,then,I run "./sqlite3" But It can't work,here are error msgs: ./sqlite3: error while loading shared libraries: libz.so.1: cannot open shared object file: No such file or directory So,What should I do for it?