[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] 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

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@maili

[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

Re: [sqlite] sqlite3_column_decltype and max and min

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 <