Re: [sqlite] SQL join syntax

On Thursday, 27 April, 2017 17:31, Joseph L. Casale inquired: > Hey guys, > So what are the semantics of the predicate on the join versus the where > clause? > Just curious... When the joins are only equijoins (inner joins) of any type: SELECT FROM JOIN ON JOIN

Re: [sqlite] SQL join syntax

On 4/27/2017 7:15 PM, Joseph L. Casale wrote: Hey guys, Need a pointer some join syntax. I have a couple where TableA is one to many on TableB. TableB structure is three columns Id,Key,Value. For each row I select in Table, I join TableB several times for each Key whose value I want in the

Re: [sqlite] Controlling the lifetime of shared-cache, in-memory SQLite databases.

On 28 Apr 2017, at 2:14am, Randall Smith wrote: > (a) Is this right? A shared-cache, in-memory database is "persistent" > across connections from the same process that do not overlap in time? Correct. SQLite doesn’t count connections and do anything special when

[sqlite] Controlling the lifetime of shared-cache, in-memory SQLite databases.

SQLite has the useful ability to provide an in-memory database that can be shared by multiple connections in the same process by opening the DB with the following syntax: rc = sqlite3_open("file:memdb1?mode=memory=shared", ); I'm testing a database having this configuration in a unit

[sqlite] Semantics regarding command instances and queries in the C# client

Typically I open a connection and a command instance and associate instantiated parameters with the command instances, then process in a loop simply changing parameter values. I have a situation when I am needing to insert and select based on several criteria and that practice looks a bit ugly.

Re: [sqlite] SQL join syntax

On 28 Apr 2017, at 12:31am, Joseph L. Casale wrote: > So what are the semantics of the predicate on the join versus the where > clause? > Just curious... SELECT FROM JOIN WHERE Simon. ___ sqlite-users mailing list

Re: [sqlite] SQL join syntax

From: sqlite-users on behalf of Simon Slavin Sent: Thursday, April 27, 2017 5:26 PM To: SQLite mailing list Subject: Re: [sqlite] SQL join syntax   > On 28 Apr 2017, at 12:21am, Keith Medcalf wrote: >

Re: [sqlite] SQL join syntax

On 28 Apr 2017, at 12:21am, Keith Medcalf wrote: > SELECT TableA.ColA Name, B.Value BV, C.Value CV > FROM TableB I think Keith means "FROM TableA" on that second line. The rest looks perfect. Simon. ___ sqlite-users mailing

Re: [sqlite] SQL join syntax

SELECT TableA.ColA Name, B.Value BV, C.Value CV FROM TableB LEFT JOIN TableB B ON TableA.Id=B.Id LEFT JOIN TableB C ON TableA.Id=C.Id WHERE TableA.ColB=42 AND (B.Key='BAR' or B.Key is null) AND (C.Key='BAZ' or C.Key is null) GROUP BY Name -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı

Re: [sqlite] SQL join syntax

> Works fine when BAR and BAZ values exist in TableB.Key. Move the predicate on to the join it seems? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQL join syntax

Hey guys, Need a pointer some join syntax. I have a couple where TableA is one to many on TableB. TableB structure is three columns Id,Key,Value. For each row I select in Table, I join TableB several times for each Key whose value I want in the single row result. How do you construct the join and

Re: [sqlite] SQLite automatic backup database on Windows Server

SQLite is a library, not a server. There is no automatic backup. You can copy the .db file when the application is inactive, or have the application call the SQLite backup API to perform the backup whenever it feels the urge to do so. -Ursprüngliche Nachricht- Von: sqlite-users

Re: [sqlite] SQLite memory calculator (was Multiple sessions, page sizes and cache)

On Wed, Apr 26, 2017 at 11:00 PM, Kim Gräsman wrote: > > I've used a spreadsheet internally to forecast how much memory SQLite > will need in a given configuration. > > I've cleaned/generalised it a little and posted here: >

[sqlite] SQLite automatic backup database on Windows Server

Hey guys, I am new on SQLite engine. Sorry for rookie mistakes. My company is running an application on windows server(hosted on Amazon Web Service) and the application contains a database. Because it is sensitive data, the database need to be automatically backed up. There is .db file on the

Re: [sqlite] SQLite memory calculator (was Multiple sessions, page sizes and cache)

Hi Simon, On Wed, Apr 26, 2017 at 11:46 PM, Simon Slavin wrote: > > On 26 Apr 2017, at 10:00pm, Kim Gräsman wrote: > >> Specifically, I wonder if 4MiB for the general-purpose heap is maybe >> entirely unreasonable? Is there a way to forecast how much

Re: [sqlite] Increasing performance of query

Gabriele Lanaro wrote: > Are there any tips to make sure that the cache is used properly? The default is 2000 pages (8 MB with the default page size), and in most cases should be increased. But what works best in your specific case depends on the hardware, the OS, the software, the database