[sqlite] Causal profiling
All, Just watched an interesting lecture by UMass professor Emery Berger on improving software performance: https://www.youtube.com/watch?v=r-TLSBdHe1A SQLite is discussed in the section on causal profiling, which begins at 34:12. Craig -- Craig H Maynard Rhode Island, USA 401.413.2376 ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Shell commands for controlling headers
All, Could someone clarify the difference between the two sqlite3 shell commands .header and .headers? The relevant documentation page: https://www.sqlite.org/cli.html On this page, .header is discussed in section 5 but does not appear in Section 3. Thanks, Craig -- Craig H Maynard Rhode Island, ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Stored Procedures
Very useful comments in this thread. I recommend adding this to the SQLite FAQ, if it exists. -- Craig H Maynard Rhode Island, USA 401-413-2376 > Date: Tue, 8 May 2018 20:56:45 -0400 > From: Richard Hipp <d...@sqlite.org> > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Subject: Re: [sqlite] Stored Procedures > Message-ID: >
[sqlite] PostgreSQL Meltdown Benchmarks
FYI, here's an article about PostgresSQL performance metrics before and after a Meltdown fix. https://blog.2ndquadrant.com/postgresql-meltdown-benchmarks/ Craig -- Craig H Maynard Rhode Island, USA 401-413-2376 ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3_column_decltype and max and min
Igor, Two comments: - Why Homebrew? Because it's an invaluable tool for keeping up with the latest release of not just SQLite but every installed package of interest. - I think you missed the point. Niall is referring to the SQLite3 executable, not just the C source file. The excutable is needed to use SQLite from the command line. Craig -- Craig H Maynard Rhode Island, USA > On Sat, 13 Jan 2018, Igor Korot <ikoro...@gmail.com> wrote: > > Why? Just include sqlite3.c in your project and recompile. > > > On Sat, Jan 13, 2018 at 6:32 AM, Niall O'Reilly <niall.orei...@ucd.ie> wrote: > >> It may be more convenient to use the [Homebrew package >> manager](https://brew.sh/), which tracks SQLite pretty closely. In order to >> avoid interfering with the Apple-supplied installation, Homebrew >> deliberately neglects to link the executable to _/usr/local/bin_, so some >> care is needed when invoking SQLite in order to run the intended version. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users