Re: [sqlite] SQLite server for Windows/Linux?

did you try www.SQLitening.com Gilles Ganault-3 wrote: > > Hello > > I know that SQLite is meant as a server-less, file server-based > solution, but... since Richard Hipp has also written a single-EXE SCM > solution (www.fossil-scm.org), I wanted to check if someone had > recently written a

[sqlite] FTS3 - closed ticket 3950 - bug still exists in 3.6.19

Hi Roger, I just downloaded SQLite3 version 3.6.19 and did the same testing as I did before: CREATE TABLE Simple (ID integer primary key, Name text); CREATE VIRTUAL TABLE SimpleFTS USING FTS3 (Name); CREATE TRIGGER DeleteTrigger AFTER DELETE ON Simple FOR EACH ROW BEGIN DELETE FROM SimpleFTS

[sqlite] How does SQLite treat repeated expressions?

Consider the two statements below. A: SELECT COUNT(DataID) FROM Data GROUP BY DataID ORDER BY COUNT(DataID); B: SELECT COUNT(DataID) AS X FROM Data GROUP BY DataID ORDER BY X; Is statement B faster than A? Why?

Re: [sqlite] FTS3 - closed ticket 3950 - bug still exists in 3.6.19

On Sun, Oct 25, 2009 at 5:33 AM, Wanadoo Hartwig wrote: > Hi Roger, > > I just downloaded SQLite3 version 3.6.19 and did the same testing as I > did before: > > CREATE TABLE Simple (ID integer primary key, Name text); > CREATE VIRTUAL TABLE SimpleFTS USING FTS3

Re: [sqlite] SQLite server for Windows/Linux?

"David Morris" schrieb im Newsbeitrag news:26044356.p...@talk.nabble.com... > > Have a peek at : http://www.sqlitening.com/support/index.php > Different language and could run under Wine on *nix Ah - yes of course, I left it out here, since it currently is "win only"

Re: [sqlite] How does SQLite treat repeated expressions?

Kristoffer Danielsson wrote: > A: SELECT COUNT(DataID) FROM Data GROUP BY DataID ORDER BY COUNT(DataID); > > B: SELECT COUNT(DataID) AS X FROM Data GROUP BY DataID ORDER BY X; > > Is statement B faster than A? Why? Last time I checked, SQLite didn't perform any kind of common subexpression

Re: [sqlite] How does SQLite treat repeated expressions?

On Sun, Oct 25, 2009 at 9:49 AM, Igor Tandetnik wrote: > Kristoffer Danielsson wrote: >> A: SELECT COUNT(DataID) FROM Data GROUP BY DataID ORDER BY COUNT(DataID); >> >> B: SELECT COUNT(DataID) AS X FROM Data GROUP BY DataID ORDER BY X; >> >> Is statement B faster than A? Why?

Re: [sqlite] How does SQLite treat repeated expressions?

Sure I can test this specific case, but my question is still relevant. Does SQLite or does it not optimize repeated expressions? Am I supposed to brute-force all possible expression repetitions to find it out, when a simple "yes" or "no" from anybody - who knows about the inner workings of

Re: [sqlite] How does SQLite treat repeated expressions?

On Sun, Oct 25, 2009 at 10:56 AM, Kristoffer Danielsson wrote: > > Sure I can test this specific case, but my question is still relevant. Does > SQLite or does it not optimize repeated expressions? > > You are correct. Stated as above, your question is very valid

Re: [sqlite] FTS3 - closed ticket 3950 - bug still exists in 3.6.19

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 >> can you please re-open the ticket? This bug only occurs in >> combination with FTS3. Using normal tables in triggers does not cause >> any problems. The underlying cause is that FTS3 has several other tables (use .dump to see them) that store its

Re: [sqlite] FTS3 - closed ticket 3950 - bug still exists in 3.6.19

On Sun, Oct 25, 2009 at 12:47 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > >>> can you please re-open the ticket? This bug only occurs in >>> combination with FTS3. Using normal tables in triggers does not cause >>> any problems. > > The

Re: [sqlite] FTS3 - closed ticket 3950 - bug still exists in 3.6.19

Hi Roger, Am 25.10.2009 um 18:47 schrieb Roger Binns: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > >>> can you please re-open the ticket? This bug only occurs in >>> combination with FTS3. Using normal tables in triggers does not >>> cause >>> any problems. > > The underlying cause is

Re: [sqlite] FTS3 - closed ticket 3950 - bug still exists in 3.6.19

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Wanadoo Hartwig wrote: >> Actually, if you replace the FTS3 table with any other type of table - >> or as many tables as you like and do also in these tables insert >> operations - the last row id of the original table is correctly >> returned.