Re: [sqlite] Vdbe Program Generation

2014-10-03 Thread Kees Nuyt
On Fri, 3 Oct 2014 18:39:29 +0530, Prakash Premkumar <prakash.p...@gmail.com> wrote: > Can you please tell me which function is > sqlite actually generates the Vdbe > program for a give sql string ? http://www.sqlite.org/c3ref/prepare.html -- Gr

Re: [sqlite] Filling struct Select in sqlite

2014-10-06 Thread Kees Nuyt
qlite3_bind() new values, sqlite3_step(), and finally sqlite3_reset() to use the same compiled statement again and again. That way, there is no need to _finalize() and _prepare() every time, and you may not need that optimization at all. -- Groet, Kees Nuyt

Re: [sqlite] passing error messages to pysqlite

2014-10-07 Thread Kees Nuyt
# Insert a row of data c.execute("""insert into stocks values ('2006-01-05','BUY','RHAT',100,35.14)""") https://pysqlite.readthedocs.org/en/latest/sqlite3.html No idea whether that solves your problem. -- Regards, Kees Nuyt ___

Re: [sqlite] In python, determine database status

2014-10-08 Thread Kees Nuyt
> > Can anyone help with some clues for me? I hope the hints above help. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Performance issue when copying data from one sqlite database to another

2014-10-14 Thread Kees Nuyt
t can be used for tuning the performance of sqlite3 > in this scenario? I suspect this is a case of http://knuyt.demon.nl/sqlite.org/faq.html#q19 -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:80

Re: [sqlite] Performance issue when copying data from one sqlite database to another

2014-10-14 Thread Kees Nuyt
On Wed, 15 Oct 2014 01:26:10 +0200, Kees Nuyt <k.n...@zonnet.nl> wrote: > http://knuyt.demon.nl/sqlite.org/faq.html#q19 Oops, make that http://www.sqlite.org/faq.html#q19 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite

Re: [sqlite] Granularity of Locks in sqlite

2014-10-17 Thread Kees Nuyt
ed database libraries don't (have to) care about concurrency at all, so the concurrency that SQLite supports is a lot already. There are enough other products available that target that market. > Thanks a lot. You're welcome. -- Regards, Kees Nuyt ___

Re: [sqlite] Remove me from this

2014-10-26 Thread Kees Nuyt
On Mon, 27 Oct 2014 07:20:04 +1100, Isaac Faulkner <ifaulkne...@students.bdc.nsw.edu.au> wrote: > > >I did not sign up for this someone hacked my email stop spamming me please Visit the link below, make it send your password, then login and unsubscribe. Rega

Re: [sqlite] Access Temp Tables/Views in background thread

2014-10-28 Thread Kees Nuyt
t; on a concurrent dispatch queue. Are you sure the temp objects are accessed via the same connection (db object) as where they were created? > Is there a better multi-threaded approach? I'll leave that to someone more experienced in threading. -- Regards, Kees Nuyt __

Re: [sqlite] querying with BLOB in WHERE clause, possible?

2014-11-14 Thread Kees Nuyt
VALUES (1,x'313131'); sqlite> INSERT INTO T VALUES (2,x'323232'); sqlite> UPDATE T SET bl=x'33' WHERE bl=x'323232'; sqlite> SELECT * FROM t; 1|111 2|333 sqlite> DELETE FROM t WHERE bl=x'313131'; sqlite> SELECT * FROM t; 2|333 sqlite> >Thank you, >Jozsef Hope this helps.

Re: [sqlite] Uncached performance

2015-01-08 Thread Kees Nuyt
=something_larger_than_default; PRAGMA cache_size= .. ; -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug in SQLite FLOAT values

2015-02-07 Thread Kees Nuyt
atitude: 1.234568, longitude: 5.678901 sqlite> Hope this helps. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Did A Recent Windows & Update Affect SQLite???

2015-04-02 Thread Kees Nuyt
room * Exclude directories with sqlite databases / Lightroom catalogs from all viruscanners. If that is not possible, (temporarily) disable all real-time virusscanners -- Regards, Kees Nuyt

[sqlite] Read data from database slow the first time but then very fast thereafter. How can I improve the speed for the first time read?

2015-08-07 Thread Kees Nuyt
On Thu, 6 Aug 2015 10:17:43 -0500, John McKown wrote: > Too bad that SQLite does not implement updatable views. Sometimes a similar construct as updatable views can be obtained with an INSTEAD OF trigger. -- Regards, Kees Nuyt

[sqlite] Enhance the SELECT statement?

2015-08-17 Thread Kees Nuyt
3 (seqno INTEGER PRIMARY KEY NOT NULL); WITH RECURSIVE generate AS ( SELECT 1 AS seqno UNION ALL SELECT seqno+1 FROM generate WHERE seqno < 10) INSERT INTO table_of_i3 (seqno) SELECT seqno FROM generate ORDER BY seqno; PRAGMA table_info(table_of_i3); .dump -- Regards, Cordialement, Groet, Kees Nuyt

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

2015-08-22 Thread Kees Nuyt
e it), but in my opinion it does not belong in the core engine that SQLite is. It's lite for good reasons. It even would be fine to me if all ALTER TABLE features would be removed. -- Regards, Kees Nuyt

[sqlite] order by not working in combination with random()

2015-08-28 Thread Kees Nuyt
recursive query in SQB take 6 min, > on other IDEs it would be less than 2 min. > > My $0.02 For exactly that reason I would advise everyone to use the sqlite3 command line tool for performance comparisons in this mailing list. -- Regards, Cordialement, Groet, Kees Nuyt

[sqlite] Compiling sqlite as as library

2015-07-01 Thread Kees Nuyt
ite3 command line tool is build using: gcc ${CFLAGS} -o sqlite3 sqlite3.c src/shell.c More info: http://www.sqlite.org/howtocompile.html I hope this helps. If you need more detailed info, please reply with the specifications of your platform. -- Regards, Kees Nuyt

[sqlite] Schema-less JSON SQLite DB?

2015-07-14 Thread Kees Nuyt
VALUES (1); INSERT INTO T1 (anint) VALUES ('two'); > I don't want to take up your time, so if there's a document I can read > about it'd be great. https://sqlite.org/datatype3.html All docs: https://sqlite.org/docs.html -- Regards, Cordialement, Groet, Kees Nuyt

[sqlite] Problems in reading a record containing a blob

2015-06-20 Thread Kees Nuyt
the app on, but it does not work on > the seventh tablet with the same OS version? > * What is the solution to this problem? Check free RAM before extracting an image. Maybe: run garbage collection and/or push other apps to background. -- Regards, Cordialement, Groet, Kees Nuyt

[sqlite] Fault on transaction begin, end, and rollback statements

2015-06-26 Thread Kees Nuyt
ed it from being overwritten with operator overloading the '=' sign. >I did this to ensure the safety of the prepared sqlite3_stmt*. Is there any chance the statement is _step()ped, _finalize()d and then re-used? To be able to use a statement multiple times, it should not be finalized but rather _reset(). >Thank you for your help, >Ch? HTH -- Regards, Kees Nuyt

[sqlite] Releasing a read (SHARED) lock

2015-03-13 Thread Kees Nuyt
the state/context of a statement. Aditionally, any BEGIN TRANSACTION should be paired with a COMMIT or ROLLBACK. >Cheers, > > - Barry -- Regards, Cordialement, Groet, Kees Nuyt

[sqlite] sqlite3 and Unicode

2015-05-05 Thread Kees Nuyt
74 31 22 020 20 56 41 4c 55 45 53 28 31 2c 27 c3 a9 c3 a9 6e 040 27 29 3b 0a 044 -- Regards, Kees Nuyt

[sqlite] Multiple Prepared Statements

2015-05-09 Thread Kees Nuyt
he statement, you can just _reset() it to finish the _step() loop and keep the statement around for reuse (with new bindings) later. _reset() will free the resources that are allocated at the first _step(). -- Regards, Kees Nuyt

[sqlite] Limit size of write-ahead log file

2015-05-19 Thread Kees Nuyt
ckpoint=N; and PRAGMA database.wal_checkpoint(); ? http://www.sqlite.org/pragma.html#pragma_wal_autocheckpoint -- Regards, Kees Nuyt

[sqlite] AUTOINC vs. UUIDs

2015-05-20 Thread Kees Nuyt
_sequence table. $ sqlite3 t2.sqlite SQLite version 3.8.11 2015-05-20 00:15:27 Enter ".help" for usage hints. sqlite> create table t(id integer primary key autoincrement, tx text); sqlite> insert into t (tx) values ('one'),('two'); sqlite> select * from sqlite_sequence; t|2 sqlite> -- Regards, Kees Nuyt

[sqlite] ALTER TABLE ADD COLUMN

2015-05-21 Thread Kees Nuyt
h your preferred layout. It is dangerous, so read the warning, make backups first and test the result thoroughly! -- Regards, Kees Nuyt

[sqlite] ALTER TABLE ADD COLUMN

2015-05-21 Thread Kees Nuyt
On Thu, 21 May 2015 12:45:41 +0200, "Christoph P.U. Kukulies" wrote: >Am 21.05.2015 um 10:00 schrieb Kees Nuyt: >> On Thu, 21 May 2015 09:40:53 +0200, "Christoph P.U. Kukulies" >> wrote: >> >>> Am 21.05.2015 um 09:25 schrieb Hick Gunter: &

[sqlite] in Linux system, 2 threads can access 2 separate databases (created by sqlite3) through sqlite3?

2015-05-22 Thread Kees Nuyt
; miles zhang > 2015-05-21 -- Regards, Kees Nuyt

Re: [sqlite] Is this a proper syntax?

2013-10-25 Thread Kees Nuyt
st as fast as when the second run was optimized out. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Ghost index?

2013-11-12 Thread Kees Nuyt
ou what you can do there. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Ghost index?

2013-11-12 Thread Kees Nuyt
;INDEX IF EXISTS 'index1'; ? Doing so still shows the index when I load the >database in SQLite Administrator. What operating system are we talking about? What is the exact full path to the database file? -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _

Re: [sqlite] SQL 2003 in sqlite

2013-11-16 Thread Kees Nuyt
d the trigger are pretty straightforward, and the SQL could probably be generated by a smart m4 macro. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL 2003 in sqlite

2013-11-17 Thread Kees Nuyt
On Sat, 16 Nov 2013 23:59:35 +0100, Petite Abeille <petite.abei...@gmail.com> wrote: > >On Nov 16, 2013, at 11:02 PM, Kees Nuyt <k.n...@zonnet.nl> wrote: > >> For the application, the merge would look like a single >> INSERT INTO merge_t statement. > >H

Re: [sqlite] SQLite server/file-locking scenario

2013-11-17 Thread Kees Nuyt
risk of reading some of it before a change and some of it after >> the change. So yes, you need some form of mutex. Or to use the SQLite >> backup API to read the file. Or to use the normal SQLite API to open the >> file read/only and read all the data. >> >> Simon. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] query optimization

2013-11-18 Thread Kees Nuyt
o write in single query? >>> >>> Regards, >>> va >>> ___ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> &g

Re: [sqlite] query optimization

2013-11-18 Thread Kees Nuyt
the discussion, so I missed part of the spec. I'm sure the OP will sort it out after so many hints :) >On 2013/11/18 13:55, Kees Nuyt wrote: >> On Mon, 18 Nov 2013 13:04:31 +0200, RSmith <rsm...@rsweb.co.za> wrote: >> >>> Oops, misprint... >>> >>&

Re: [sqlite] SQlite3 Query Format for Export

2013-11-19 Thread Kees Nuyt
.mode line sometimes, which is easy to postprocess, or .mode list with .separator '\001', if the data is suitable. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Insert with multiple nested selects.

2013-11-24 Thread Kees Nuyt
FROM table_c WHERE name=?) ); >Thanks, >jlc HTH -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Inefficient query plan in queries with multiple joins

2013-11-30 Thread Kees Nuyt
to reduce the size of the intermediate result set. For faster pagination, read : http://sqlite.org/cvstrac/wiki?p=ScrollingCursor -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://s

Re: [sqlite] SQLite ver: 1.0.89 issue

2013-12-02 Thread Kees Nuyt
you will get better/quicker/more answers if you also post: - a minimal set of sample data that can demonstrate the problem - expected result - obtained result -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list s

Re: [sqlite] sqlite download for 64 bit

2013-12-09 Thread Kees Nuyt
32 bit works fine on 32-bit and 64-bit Windows OS. Only for very large databases you may need SQLite compiled for 64 bit. Typically, that is not something a newbie would do. >Regards >Krishna -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

2013-12-15 Thread Kees Nuyt
erties / security / advanced / etc.) Remark: Do you know that concurrent access to sqlite files on network shared filesystems is not safe? -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.

Re: [sqlite] Bug: PRAGMA busy_timeout outputs the value, screws up html

2013-12-25 Thread Kees Nuyt
d, there is an easy workaround (oneliner wrapped by mail) : printf ".output stderr\nPRAGMA busy_timeout =1000;\n.output stdout\ncreate table foo as select 1 as c;select * from foo;" |sqlite3 2>/dev/null -html -header :memory: yields: c 1 -- Groet, Cordialement, Pozdrawiam,

Re: [sqlite] select only records with fields that BEGIN with a certain sub-string

2013-12-26 Thread Kees Nuyt
-- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How to build sqlite3 on [Open]Solaris

2014-01-16 Thread Kees Nuyt
&& make \ && mv -f fossil ${HOME}/usr/bin/fossil \ && make clean \ && cd set +xv } On Solaris, I complie trunk every now and then, on MS Windows, I run the released executables. I'll try the same on XStreamOS shortly. http:/

Re: [sqlite] Simple data conversion in SQLite - please help

2014-01-22 Thread Kees Nuyt
Some simple experiments will tell you. I hope this helps. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Transaction behaviour

2014-01-23 Thread Kees Nuyt
the database. http://sqlite.org/c3ref/get_autocommit.html can help you decide what mode you are in. By the way, autocommit is not the best thing to do if you have related insert/update/delete statements in an application transaction. Related updates should be in the same, at

Re: [sqlite] help needed for major SQLite problem

2014-02-08 Thread Kees Nuyt
at give anyone a better idea of what could be happening and how I >> can fix this problem? > >Looks like GetFileAttributesEx() might be throwing an ERROR_ACCESS_DENIED >exception. Maybe a virus scanner or some other background process had >temporarily locked the database file. &g

Re: [sqlite] help needed for major SQLite problem

2014-02-10 Thread Kees Nuyt
On Mon, 10 Feb 2014 14:18:18 -0500, C M <cmpyt...@gmail.com> wrote: >On Sat, Feb 8, 2014 at 4:28 AM, Kees Nuyt <k.n...@zonnet.nl> wrote: >> >> On Sat, 08 Feb 2014 12:06:01 +0700, Dan Kennedy >> <danielk1...@gmail.com> wrote: > > > >> >&

Re: [sqlite] Bug in SQLite 3.8.2

2014-02-12 Thread Kees Nuyt
be a literal but an identifier, just like table names and column names.) -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about how sqlite recovers after a power loss

2014-02-15 Thread Kees Nuyt
the journal file will be replayed and deleted. > > Is my understanding correct? Yes. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Delete From Not Working Properly

2014-02-21 Thread Kees Nuyt
e that >has attempted to figure this out has been stumped. I am using Microsoft >Visual Studio 2012 and C++. Which version of MS Windows? What is the path to the database file? Is the database perhaps stored in a "protected" directory? Any errors on execution of the BEGIN and COMMI

Re: [sqlite] New

2014-02-28 Thread Kees Nuyt
one knows a better way to read and understand the files I would > greatly appreciate it >I think the file ext. is a plist. >Live, love & laugh. > -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing

Re: [sqlite] sqLlite default value setting

2014-03-06 Thread Kees Nuyt
eta is not fit for general availability. HTH -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQL quine using with

2014-03-08 Thread Kees Nuyt
a oneliner References: http://en.wikipedia.org/wiki/Quine_(computing) http://sqlite.org/lang_with.html Enjoy! -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http:/

Re: [sqlite] Windows user app to display input form + reporting?

2014-03-12 Thread Kees Nuyt
ned and reasonably up to date. HTH -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with sqlite3_exec

2014-03-15 Thread Kees Nuyt
o wrap the statements in a transaction. BEGIN; DELETE FROM table1 WHERE ...; DELETE FROM table2 WHERE ...; COMMIT; -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] very slow fdsync() calls

2014-03-20 Thread Kees Nuyt
. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Date in gridview visualized in YYYY-MM-DD format:

2014-03-20 Thread Kees Nuyt
You can use one of the date formatting functions in your select statement to change the presentation. http://sqlite.org/lang_datefunc.html -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.o

Re: [sqlite] Use of AUTOINCREMENT

2014-03-28 Thread Kees Nuyt
N. I wouldn't worry about it unless you are in a very fast real-time environment. Premature optimization is the root of all evil. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there a way to load a blob from the shell?

2014-04-07 Thread Kees Nuyt
, thanks! [Open]Solaris users may want to add: CC += -D_XOPEN_SOURCE=500 -O2 to the Makefile. For completeness, I also added target: clean: -rm sar sqlite3.o -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users

Re: [sqlite] sqlite3_analyzer source code

2014-04-15 Thread Kees Nuyt
ailable in the online fossil repository, http://www.sqlite.org/cgi/src/doc/trunk/README.md The Makefile will tell you what sqlite3_analyzer is made of. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-

Re: [sqlite] printf function is shown in docs but not found when I try it

2014-04-19 Thread Kees Nuyt
e cycle. I'm afraid it is totally extinct by now, but you might be lucky. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] BLOBs and NULLs

2014-04-21 Thread Kees Nuyt
) NULLs are not a problem by themselves, they take hardly any storage at all, ust the type indicator that every every row has for every column. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.o

Re: [sqlite] foreign keys

2014-04-25 Thread Kees Nuyt
(a not null references T(a)); ? > insert into U values(4) > > and it works but i don't want to, because the value 4 is not in T. > I've tried PRAGMA foreign_keys first, but it's the same. Old version perhaps? -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt

Re: [sqlite] duplicate row in sqlite3 database

2014-05-08 Thread Kees Nuyt
in the table definition in an ON CONFLICT clause: http://sqlite.org/lang_conflict.html -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Suggestion for shell .IMPORT improvement

2014-05-22 Thread Kees Nuyt
ery close: http://www.sqlite.org/sar/doc/trunk/README.md -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Simple Select from IN - from a newbie.

2014-05-24 Thread Kees Nuyt
,...,colN=valN . The WHERE cluase determines which rows are updated. >Cheers. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Simple Select from IN - from a newbie.

2014-05-25 Thread Kees Nuyt
mId,personId,orderId) VALUES (1,3,4,0),(2,3,5,1),(3,7,4,1),(4,7,5,0); or even: REPLACE INTO TeamPersonTable (tpId,teamId,personId,orderId) VALUES (1,3,4,0),(2,3,5,1),(3,7,4,1),(4,7,5,0); http://www.sqlite.org/lang_insert.html -- Groet, Cordialement, Pozdrawiam, Regards

Re: [sqlite] Porting SQLite to Nurit OS ver

2014-07-02 Thread Kees Nuyt
egister map, > to one of your posts ? Make sure we can see both the full > error text and which line of code it's complaining about. The error report was included, you just have to scroll down a bit more. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___

Re: [sqlite] Problem with many connections

2014-07-03 Thread Kees Nuyt
ssed this sentence, but to be honest, it seems to be > very confusing behaviour. Perhaps http://www.sqlite.org/c3ref/next_stmt.html is useful here. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug? sqlite3_column_name returns name of PK for rowid

2014-07-04 Thread Kees Nuyt
hidden, yet accessible. Without INTEGER PRIMARY KEY, the ROWID is still there, but it is hidden. Check it with PRAGMA table_info(test); You will see the id column, never a ROWID column. I think this behaviour is consistent with http://sqlite.org/lang_createtable.html#rowid , and the naming you observ

Re: [sqlite] Hello, I would like to know the difference between sqlite2 and sqlite3!

2014-07-13 Thread Kees Nuyt
2 databases to sqlite3. sqlite3 is current and actively maintained / optimized. Differences (as perceived almost 10 years ago): http://knuyt.demon.nl/sqlite.org/version3.html Release history: http://knuyt.demon.nl/sqlite.org/changes.html Hope this helps. -

Re: [sqlite] Hello, I would like to know the difference between sqlite2 and sqlite3!

2014-07-13 Thread Kees Nuyt
abases to sqlite3. sqlite3 is current and actively maintained / optimized. Differences (as perceived almost 10 years ago): http://www.sqlite.org/version3.html Release history: http://www.sqlite.org/changes.html Hope this helps. -- Regards, Kees Nuyt ___

Re: [sqlite] capturing and testing a hot journal

2014-07-14 Thread Kees Nuyt
ectories with backups, and an application level synchronisation/recovery mechanism to reconstruct the main database from the backup when needed. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Brief intro to SQLite in Python

2014-07-14 Thread Kees Nuyt
iple-quoting needed for > .execute(). His follow-up article is nice too: <http://sebastianraschka.com/Articles/2014_sqlite_in_python_tutorial.html> -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sql

Re: [sqlite] capturing and testing a hot journal

2014-07-14 Thread Kees Nuyt
On Mon, 14 Jul 2014 12:09:46 +0100, Simon Slavin <slav...@bigfraud.org> wrote: > On 14 Jul 2014, at 11:19am, Kees Nuyt <k.n...@zonnet.nl> wrote: > > > On Sun, 13 Jul 2014 18:00:59 +0100, Simon Slavin <slav...@bigfraud.org> > > wrote: > > > >

Re: [sqlite] sqlite db transfer

2014-07-17 Thread Kees Nuyt
ubt sqlite browser would be able to open an encrypted SQLite database. Hope this helps -- Regards, Kees Nuyt >On Fri, May 9, 2014 at 6:05 PM, Simon Slavin <slav...@bigfraud.org> wrote: > >> >> On 9 May 2014, at 1:23pm, Sky Meena <sky.me...@gmail.com> wrote: >>

Re: [sqlite] Setting boundaries in a search

2014-07-17 Thread Kees Nuyt
On Thu, 17 Jul 2014 13:06:36 +0530, Sky Meena <sky.me...@gmail.com> wrote: > how to set a password to open a sqlite db in sqlite browser Answered in a different thread 2 minutes ago. -- Regards, Kees Nuyt >On Thu, Jul 17, 2014 at 7:18 AM, RSmith <rsm...@rsw

Re: [sqlite] Creating fiels

2014-07-18 Thread Kees Nuyt
>Kind regards, > >Miguel Fernandes -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3 has stopped working

2014-07-28 Thread Kees Nuyt
valid pointer, possibly by a programming error or some form of memory (heap) corruption. Try to run the program with a debugger to pinpoint the error. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@s

Re: [sqlite] After ANALYZE all has become slow

2014-08-08 Thread Kees Nuyt
On Fri, 8 Aug 2014 11:14:29 +0200, Giuseppe Costanzi <giuseppecosta...@gmail.com> wrote: >>>> sqlite3.sqlite_version >'3.5.9' Version 3.5.9 is more than 6 years old. A lot of optimizations were introduced since that version. Please upgrade and try again.

[sqlite] presentation about ordering and atomicity of filesystems

2014-09-11 Thread Kees Nuyt
Talk at usenix 2014 Published on Sep 4, 2014 by USENIX Association Videos Somewhat related to the article drh recently wrote about using sqlite as an application data store. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-11 Thread Kees Nuyt
On Thu, 11 Sep 2014 23:49:22 +0200, Kees Nuyt <k.n...@zonnet.nl> wrote: > Today I bumped into a presentation about ordering and atomicity > of filesystems that might interest you. > > https://www.youtube.com/watch?v=YvchhB1-Aws Compliments for sqlite

Re: [sqlite] Reinstalling My Build Environment

2014-09-12 Thread Kees Nuyt
st approximation to an > answer, whether they understand the question or not. > > If such document already exists, could someone post a pointer ? Sure, it's all available at https://system.data.sqlite.org/ I think the material there covers most of the questions. -- Groet, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] write internal blob vs external file

2014-09-12 Thread Kees Nuyt
rtunity: printf "PRAGMA page_size=bytes; VACUUM;\n" \ | sqlite3 benchmark.sqlar >Eric > >References: > >http://sqlite.1065341.n5.nabble.com/Internal-v-External-BLOBs-td15515.html >http://www.sqlite.org/intern-v-extern-blob.html -- Groet, Kees Nuyt __

Re: [sqlite] Reinstalling My Build Environment

2014-09-12 Thread Kees Nuyt
On Fri, 12 Sep 2014 23:23:39 +0100, Simon Slavin <slav...@bigfraud.org> wrote: > >On 12 Sep 2014, at 10:33pm, Kees Nuyt <k.n...@zonnet.nl> wrote: > >> Sure, it's all available at >> https://system.data.sqlite.org/ >> >> I think the mater

Re: [sqlite] sqlite db is locked on network drive

2014-09-12 Thread Kees Nuyt
en database corruption can result. One should note that POSIX advisory locking is known to be buggy or even unimplemented on many NFS implementations (including recent versions of Mac OS X) and that there are reports of locking problems for network filesystems under Windows. Your best defense is to n

Re: [sqlite] sqlite db is locked on network drive

2014-09-12 Thread Kees Nuyt
On Sat, 13 Sep 2014 00:55:23 +0200, Kees Nuyt <k.n...@zonnet.nl> wrote: > It works better on your local filesystem. Perhaps you can configure (a partition on) the Seagate GoFlex as an iSCSI target and configure an iSCSI initiator on the PC ? A quick websearch on "seagate goflex i

Re: [sqlite] BUG: Aggregate functions in subqueries

2014-09-14 Thread Kees Nuyt
RE x=(SELECT max(x) FROM t1); 3 4 -- Groet, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite max arguments assistance

2014-09-22 Thread Kees Nuyt
. > Is there anything I can do post export from the other database to change the > values correctly? Have a look at http://sqlite.org/datatype3.html "2.3 Column Affinity Behavior Example" -- Groet, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Insert BLOB data from the command line

2011-03-30 Thread Kees Nuyt
nts) VALUES ('$f',X'$(od -A n -t x1 $f|tr -d '\r\n\t ')');" | sqlite3 $d ; done HTH -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] read full txt file in one record

2011-04-06 Thread Kees Nuyt
,contents BLOB);" | sqlite3 $d ; for f in yourfiles* ; do echo "INSERT INTO Files (name,contents) VALUES ('$f',X'$(od -v -A n -t x1 $f|tr -d '\r\n\t ')');" | sqlite3 $d ; done It might not be what you're looking for. -- ( Kees Nuyt ) c[_] ___ s

Re: [sqlite] Persistently setting certain PRAGMAs (foreign_keys, recursive_triggers)

2011-04-17 Thread Kees Nuyt
ULT_* . See the README file in the amalgamation tarball http://www.sqlite.org/sqlite-autoconf-3070601.tar.gz Note: Changing the defaults make your SQL less portable to other SQLite instances. -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list

Re: [sqlite] installing sqlite

2011-04-19 Thread Kees Nuyt
hoice. Or, if you prefer a GUI tool: Install the Firefox web browser from http://www.mozilla.com/en-US/firefox/new/ and add the SQLite manager add-on from https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ I have no idea wether all that is compatible with Windows NT. Windows XP and lat

Re: [sqlite] Foreign keys bypassed on insert?

2011-04-24 Thread Kees Nuyt
: near line 8: foreign key constraint failed INSERT INTO child SELECT s1 FROM source; Error: near line 9: foreign key constraint failed SELECT * FROM child; -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Issue 608 in sqlite-manager: select date('2011-04-29', quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17

2011-05-08 Thread Kees Nuyt
e, karmic, >of package firefox, now requires sqlite 3.7.xx, while the version >installed on this system still is 3.6.16. Is that a problem? On many platforms, firefox installs its own libsqlite3.so, e.g. in /usr/lib/mps, so it doesn't require a specific system-wide sqlite3 version. I don't kno

Re: [sqlite] sqlite3_step hold about 0.5sec in iphone.

2011-05-21 Thread Kees Nuyt
and calling sqlite3_reset(). This papge might be of interest for you: http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bulk insert performance

2011-05-29 Thread Kees Nuyt
On Sun, 29 May 2011 10:35:51 +1000, "Greg Keogh" <g...@mira.net> wrote: > I'm utterly gobsmacked by the poor performance of the > inserts without a transaction around them. It's a FAQ, http://www.sqlite.org/faq.html#q19 explains the reasons quite clearly. --

  1   2   3   4   5   6   7   8   9   >