Re: [sqlite] Common Multi-treaded Problem

er guys for explaining these things in-depth! /off-topic Mihai -- Mihai Militaru ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Common Multi-treaded Problem

the transaction? Also, is this something that one should immediately deduce, necessary behavior based on the model of SQLite (or perhaps RDBMS, ACID), or is it something that one normally learns by heart, being, for the end-user, just the way SQLite works? T

Re: [sqlite] Automating the build of a sqlite database

(I normally use MSYS when I need something done in command-line on Windows) -- Mihai Militaru ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Automating the build of a sqlite database

o do something similar on Windows cmd? -- Mihai Militaru ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to reuse a prepared statement

er to use it, it's easier to debug a problem involving an unwelcome NULL than an arbitrary incorrect entry, in case something goes wrong. -- Mihai Militaru ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] date field with default current date

On Thu, 21 Apr 2011 15:17:00 +0200 Fabio Spadaro wrote: > Does not work on python with sqlite3 module Try using the date and time functions, 'date' or 'datetime' in your case: INSERT INTO table(..., date) VALUES(..., datetime('now')); http://www.sqlite.

Re: [sqlite] Multiple Match statements per query

the first NULL - normally the end; - the fourth is a pointer to your new unallocated statement; I think copying the bindings is possible using sqlite3_bind_parameter_* and something else I can't figure out right now. -- Mihai Militaru ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Capitalisation

Access - do not have this > disadvantage. My opinion is that matching the exact string you want is not a "disadvantage", 'tra001' and 'TRA001' are different things, why would the equal sign match them?... -- Mihai Militaru ___

Re: [sqlite] Question about database design

t? > > No, it doesn't. Use EXPLAIN QUERY PLAN to see what SQLite3 is doing. Hmm SqLite does create persistent indices on UNIQUE - and consequently PRIMARY - keys, doesn't it? -- Mihai Militaru ___ sqlite-users mailing list sqlite-use

Re: [sqlite] GUI for data entry

d > totals, convert date reals to human readable text, integer amounts to > currency etc. > > But what few database designers seem to exploit is the fact that > views can also be used to accept user input and convert that into > meaningful entry into the underlying related tab

Re: [sqlite] Insert or Update (was: ON DELETE CASCADE along with ON CONFLICT REPLACE)

BEFORE INSERT ON users BEGIN UPDATE users SET type=NEW.type, id=NEW.id WHERE name=NEW.name; END ...then in my code I use only: INSERT OR IGNORE INTO users(name,type,id) VALUES(?,?,?); It w

Re: [sqlite] gui for data entry

On Wed, 13 Oct 2010 18:15:54 +0300 Mihai Militaru wrote: > That is what I am using, but unless I am missing something, it doesn't > let me create a form for data entry. Please pardon my distraction, Graham, I didn't read your post carefully. My recommendation was general-pur

Re: [sqlite] gui for data entry

I use the Mozilla add-on, it's very handy and it gets updated. https://addons.mozilla.org/en-US/firefox/addon/5817/ It currently uses SQLite version 3.6.22. -- Mihai Militaru ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlit