Re: [sqlite] Stream loading SQL script

SQL script On Sunday, 27 October, 2019 07:40, x wrote: >Where is this function Keith? I can find any information on it? The SQLite3 command line shell (shell.c) reads input from stdin or other file and processes the commands one at a time by either calling the appropriate sqlite3 functi

Re: [sqlite] LEFT JOIN: ON vs. WHERE

If I remember correctly I found out by mistake that the ON doesn’t even have to relate to the JOIN it follows as long as it fits in with the WHERE. E.g. SELECT * FROM Tbl1 INNER JOIN Tbl2 ON Tbl3.Col=Tbl1.Col INNER JOIN Tbl3 ON Tbl2.Col=Tbl1.Col; Something like that.

[sqlite] ALTER TABLE ADD COLUMN

From the documentation “A record might have fewer values than the number of columns in the corresponding table. This can happen, for example, after an ALTER TABLE ... ADD COLUMN SQL statement has increased the number of columns in the table schema without modifying preexisting rows in the

Re: [sqlite] ALTER TABLE ADD COLUMN

Sent: Wednesday, October 23, 2019 2:09:19 PM To: SQLite mailing list Subject: Re: [sqlite] ALTER TABLE ADD COLUMN Wednesday, October 23, 2019, 1:53:10 PM, x wrote: > From the documentation > “A record might have fewer values than the number of columns in the > corresponding table. Th

[sqlite] 3.31

I’m eager to try out the new virtual columns (thanks Richard and team). Is it imminent or is there a beta for testing? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] 3.31

Thanks Richard. From: sqlite-users on behalf of Richard Hipp Sent: Monday, November 4, 2019 11:55:31 AM To: SQLite mailing list Subject: Re: [sqlite] 3.31 On 11/4/19, x wrote: > I’m eager to try out the new virtual columns (thanks Richard and t

[sqlite] Is Comment column in 'EXPLAIN' blank?

I get the comments using the shell but running an explain query in c++ using sqlite3.c (from 3.30 amalgamation) column 7 is returning blank in every row. Is something up or is it my code? ___ sqlite-users mailing list

Re: [sqlite] Is Comment column in 'EXPLAIN' blank?

ot; though. Is that setting one that's not reported by that pragma? -Original Message- From: sqlite-users On Behalf Of x Sent: Friday, January 31, 2020 6:22 AM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Is Comment column in 'EXPLAIN' blank? I get the comments using the shell b

[sqlite] Table has different rootpage in EXPLAIN and sqlite_master

Differing by 1. I noticed this today for 1 table only but not always - sometimes they were equal. I’ve been unable to reproduce it after a vacuum. Does this indicate a corrupt db or is it a case of it can happen for some reason I’ve missed? ___

Re: [sqlite] Table has different rootpage in EXPLAIN and sqlite_master

? Was there another index or table whose root page is what was listed in the explain output? For example, were you expecting it to use the table, but it used a covering index instead? -Original Message- From: sqlite-users On Behalf Of x Sent: Monday, February 3, 2020 1:07 PM To: Discussion

Re: [sqlite] WITHOUT ROWID tables

Re my earlier post (which didn’t go out to mailing list) sqlite3_table_column_metadata(db,dbName,tblName,"rowid",0,0,0,0,0)==SQLITE_OK returns false if table tblName is a without rowid table seems to work for me. Sent from Mail for Windows 10

[sqlite] Find schema of a table in a query

Suppose you’re given a query ‘SELECT 1 from tbl’ by a user and you want to know the name of the schema that tbl belongs to. What’s the easiest way to do this? I know sqlite will use temp.tbl if it exists else main.tbl if it exists else it will search for the earliest attached schema with a

Re: [sqlite] Find schema of a table in a query

On Sun, Jan 19, 2020 at 9:47 AM x wrote: > Suppose you’re given a query ‘SELECT 1 from tbl’ by a user and you want to > know the name of the schema that tbl belongs to. What’s the easiest way to > do this? Set an authorizer. Requires to write code though, cannot be done in S

Re: [sqlite] Find schema of a table in a query

. From: sqlite-users on behalf of Warren Young Sent: Sunday, January 19, 2020 4:02:40 PM To: SQLite mailing list Subject: Re: [sqlite] Find schema of a table in a query On Jan 19, 2020, at 2:41 AM, x wrote: > > I was hoping for something simpler. Such as?

Re: [sqlite] Find schema of a table in a query

they are. From: sqlite-users on behalf of Keith Medcalf Sent: Sunday, January 19, 2020 8:32:06 PM To: SQLite mailing list Subject: Re: [sqlite] Find schema of a table in a query On Sunday, 19 January, 2020 01:47, x wrote: >Suppose you’re given a query ‘SELECT 1 from tbl’ by a user and

Re: [sqlite] Find schema of a table in a query

us. The table search >order for unqualified names (when a search is required) is always in the >seq returned by pragma database_list, so > >select name > from pragma_database_list as d > where exists (select * > from pragma_table_info >where sche

Re: [sqlite] Find schema of a table in a query

Thanks Simon. From: sqlite-users on behalf of Simon Slavin Sent: Monday, January 20, 2020 4:49:04 PM To: SQLite mailing list Subject: Re: [sqlite] Find schema of a table in a query On 20 Jan 2020, at 2:53pm, x wrote: > Is this possible in sql? In

Re: [sqlite] Find schema of a table in a query

> select name from pragma_database_list d > where (select name from pragma_table_info(?1) where schema==d.name) > order by seq!=1, seq limit 1; Is this possible in sql? Given a variable ?1 which contains a valid attached DB name is it possible to retrieve the contents of ?1.table_name ??

Re: [sqlite] SQL help

LOL. English isnae oor furst language either. Ye ken whit a mean.  From: sqlite-users on behalf of Jose Isaias Cabrera Sent: Monday, December 30, 2019 9:50:22 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQL help x, on Saturday

Re: [sqlite] SQL help

Thanks Barry. I think that’s saying something like what I was saying but I put it better than them. I’m buoyed by the fact it’s not just Scottish education that could be done gooder  From: Barry Smith Sent: 28 December 2019 22:49 To: SQLite mailing

Re: [sqlite] SQL help

Thanks Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQL help

Consider the following sqlite> create table t1(a int, b int, c int); sqlite> create table t2(a int, b int); sqlite> insert into t1 values (1, 2, 3); sqlite> insert into t2 values (3, 4); sqlite> select a,(select b, c from t2 where t2.a=t1.a)=(3,3) from t1; 1| In the embedded select it takes c

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

* I truly hope Keith you'll continue making your tremendous contributions to the SQLite community. Ditto. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] help with understanding the C interface

int sqlite3_open( const char *filename, /* Database filename (UTF-8) */ sqlite3 **ppDb /* OUT: SQLite db handle */ ); int sqlite3_open16( const void *filename, /* Database filename (UTF-16) */ sqlite3 **ppDb /* OUT: SQLite db handle */ ); I'm trying to write a more

[sqlite] Periodical dump of in-memory database into a disk file

Hi, I have a sqlite in-memory databse that I want to periodically dump to a disk file (so I can look into its contents at runtime). Currently I "ATTACH" an extern file. Periodically I export everything from in-memory databse into the attached extern file and do a final COMMIT. However, this

Re: [sqlite] Periodical dump of in-memory database into a disk file

ng "PRAGMA synchronous = OFF;" after you open your connection. Cheers, Shawn Wilsher Mozilla Developer On Thu, Jul 10, 2008 at 3:04 PM, X Wang <[EMAIL PROTECTED]> wrote: > Hi, I have a sqlite in-memory databse that I want to periodically dump to a disk file (so I can look into its

[sqlite] cygwin compilation failure, cvs tarball, mailing list restriction on message size

to [EMAIL PROTECTED]' collect2: ld returned 1 exit status make: *** [sqlite3] Error 1[attachment "cygcheck.out" deleted by Terrence X Brannon/JPMCHASE] == cvs tarball == I am behind a firewall and cannot get the cvs sources. Is there some option to get a tarball of the cvs tree? I thought I

[sqlite] Re: cygwin compilation failure, cvs tarball, mailing list restriction on message size

I just tried the CVS from home. Exact same error. -- Terrence Brannon - SID W049945 614-213-2475 (office) 614-213-3426 (fax) 818-359-0893 (cell) Terrence X Brannon/JPMCHASE 10/18/2007 11:21 AM To sqlite-users@sqlite.org cc Subject cygwin compilation failure, cvs tarball, mailing list

Re: [sqlite] Re: cygwin compilation failure, cvs tarball, mailing list restriction on message size

Well, I'm not looking for shell.c or main.c ... perhaps the build process is , but not me. I typed ./configure && make and what you see is what I got instead. So perhaps the build process is looking for something it shouldnt. -- Terrence Brannon - SID W049945 614-213-2475 (office)

Re: [sqlite] Appropriate uses for SQLite

edded environments where actual power consumption is a limiting factor. " -- Is it really a good idea to network a data base that relies on the OS file systems like this? Is it ever going to be safe enough? ---- David M X Green |||"Alex Roston" (2007-02-02 20:05) wrote

[sqlite] sqlite3 with cygwin - bash & rxvt-bash interaction

ith some remaining problems. Any way of fixing these issues? Thank you David M X Green - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Appropriate uses for SQLite

& testing the system carefully when multiple writes may be an issue due to bugs in the file system locking. Moreover, like sqlite, other databases are known to work well relying on the system file locking. David --- David M X Green |||"Mike Owens" (2007-02-1

[sqlite] Appropriate uses for SQLite

Hi SQLite users Thank you for your attention - I am just hoping for some clarification of usability of SQLite. Referring to: http://www.sqlite.org/whentouse.html - SQLite works well in websites - Other RDBMS may work better for Client/Server applications - SQLite will work over a network file

RE: [sqlite] Appropriate uses for SQLite

database/tables, then PostgreSQL or MySQL may be the more appropriate choice. They are designed to be distributed (hence their increased overhead) while SQLite is designed to be lean-and-mean. Just my 2 cents worth... Phil On Feb 1, 2007, at 7:03 PM, Anil Gulati -X ((agulati - Michael Page at Cisco

RE: [sqlite] Appropriate uses for SQLite

have designed, I have an automatic process that dumps the db to a text file every 4 hours or so. These are kept for a couple of days. I sleep easy at night knowing this... Phil On Feb 1, 2007, at 7:59 PM, Anil Gulati -X ((agulati - Michael Page at Cisco)) wrote: > Thanks for replying P

RE: [sqlite] Appropriate uses for SQLite

tomated backups some degree of comfort may be realized. With the db > systems that I have designed, I have an automatic process that dumps > the db to a text file every 4 hours or so. These are kept for a > couple of days. I sleep easy at night knowing this... > > Phil > > On F

RE: [sqlite] Appropriate uses for SQLite

Of Light Software http://www.polsoftware.com/ -Original Message- From: Anil Gulati -X (agulati - Michael Page at Cisco) [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 8:27 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Appropriate uses for SQLite That's what I'm

RE: [sqlite] Appropriate uses for SQLite

database/tables, then PostgreSQL or MySQL may be the more appropriate choice. They are designed to be distributed (hence their increased overhead) while SQLite is designed to be lean-and-mean. Just my 2 cents worth... Phil On Feb 1, 2007, at 7:03 PM, Anil Gulati -X ((agulati - Michael Page at Cisco

RE: [sqlite] Appropriate uses for SQLite

To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite "Anil Gulati -X \(agulati - Michael Page at Cisco\)" <[EMAIL PROTECTED]> wrote: > > I am trying to decide whether I can use SQLite for a website that runs > on 4 load-balanced servers using netwo

RE: [sqlite] Appropriate uses for SQLite

for SQLite's ability and performance and it's nice to be able to prove that SQLite does actually compete in areas it was not even designed for. Perhaps an argument for less complex design as a generic software design strategy. -Original Message- From: David M X Green [mailto:[EMAIL PROTECTED

RE: [sqlite] Appropriate uses for SQLite

gives us an advantage by minimizing network and disk traffic and avoiding repeated process creation and destruction. In your application my reaction would be to run PostgreSQL or similar (maybe the new free version of DB/2) on one of your servers and connect from the others. Anil Gulati -X (agulati

<    1   2   3