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 exists. mark@b:~$ uname -a Linux b 4.19.0-8-amd64 #1 SMP Debian 4.19.98-1 (2020-01-26) x86_64 GNU/Linux mark@b:~$ dpkg -S libz.so.1 zlib1g:amd64: /lib/x86_64-linux-gnu/libz.so.1 zlib1g:amd64: /lib/x86_64-linux-gnu/libz.so.1.2.11 -- Mark Lawrence ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[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 recent changes in the LetsEncrypt certbot. Background: The althttpd.c webserver has nothing to do with SQLite, except for the fact that it was created to host the https://sqlite.org/ website, and the source code to althttpd.c is hosted on the SQLite documentation repository. See the althttpd documentation and source code here: https://www.sqlite.org/docsrc/doc/trunk/misc/althttpd.md https://www.sqlite.org/docsrc/doc/trunk/misc/althttpd.c Reason for the change: Today, I was notified by LetsEncrypt that they will be revoking some certs because of a bug in their website validation system. The cert for sqlite.org was among those being revoked. Owners of those certs were advised to get a new cert before tomorrow. But in the meantime, LetsEncrypt has modified their certbot so that it no longer worked with the legacy althttpd. Althttpd takes certain security precautions that are incompatible with the new LetsEncrypt certbot. So, in order to get a new cert, althttpd had to be modified to make an exception to the security precautions for LetsEncrypt. So, if you are one of the handful of people who are using althttpd.c for your own website, you should probably download the new althttpd.c source file and recompile. You will almost certainly need to do this before you get your next cert from LetsEncrypt. And you might need to do that before tomorrow. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[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 LightSpeed, the company found that it could replace much of this functionality with the widely used SQLite open-source database. 'We made a bigger bet on it,' says Agsen. 'Things we would have done in memory, we put in a database.'" ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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 aggregate) the query will not be flattened (#16) OK. I was more trying to find out whether such nested "ordered" projections were a standard-SQL thing or not. > select x,y from (select x, y from t order by y) order by x; > will do two order-by sorts to obtain the result even though the query could > be (in this particular case) re-written as "select x, y from t order by x, y" That's assuming the sort is "stable" :) Stable-sort is typically slower than non-stable-sort, that's why the STL has std::sort and std::stable_sort. > This is why putting an "order by" in a view will usually preclude query > flattening because the view is not merely producing a "set of rows" it is > producing an "ordered projection" and the ordering must be significant else > it would not be there. I would actually prefer these nested order-by to be ignored, and the "set of rows" being assumed, forcing the outer query to do its own ordering. The very notion of "ordered projection" for nested query sounds more like an implementation detail, to word-around the lack of window functions, than something "official" from the SQL standard or relational theory. I'm not disputing how SQLite implements things, for historical or practical reasons, I just want to understand whether such "ordered projection" is an official concept from SQL or just an SQLite thing. --DD ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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 zlib1g:i368 (alternately, you can download the sqlite source and compile your own binary which will be amd64 compatible) -Rowan On Tue, 3 Mar 2020 at 16:42, suanzi wrote: > 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-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users