Re: [sqlite] Remove me from this

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] Granularity of Locks in sqlite

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] Performance issue when copying data from one sqlite database to another

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] Performance issue when copying data from one sqlite database to another

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] In python, determine database status

> > 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] passing error messages to pysqlite

# 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] Filling struct Select in sqlite

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] Vdbe Program Generation

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] sqlite max arguments assistance

. > 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] BUG: Aggregate functions in subqueries

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 db is locked on network drive

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] sqlite db is locked on network drive

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] Reinstalling My Build Environment

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] write internal blob vs external file

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

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] presentation about ordering and atomicity of filesystems

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

[sqlite] presentation about ordering and atomicity of filesystems

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] After ANALYZE all has become slow

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.

Re: [sqlite] sqlite3 has stopped working

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] Creating fiels

>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] Setting boundaries in a search

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] sqlite db transfer

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] capturing and testing a hot journal

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] Brief intro to SQLite in Python

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

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] Hello, I would like to know the difference between sqlite2 and sqlite3!

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] Hello, I would like to know the difference between sqlite2 and sqlite3!

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] Bug? sqlite3_column_name returns name of PK for rowid

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] Problem with many connections

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] Porting SQLite to Nurit OS ver

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] Simple Select from IN - from a newbie.

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] Simple Select from IN - from a newbie.

,...,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] Suggestion for shell .IMPORT improvement

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] duplicate row in sqlite3 database

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] foreign keys

(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] BLOBs and NULLs

) 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] printf function is shown in docs but not found when I try it

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] sqlite3_analyzer source code

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] Is there a way to load a blob from the shell?

, 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] Use of AUTOINCREMENT

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] Date in gridview visualized in YYYY-MM-DD format:

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] very slow fdsync() calls

. -- 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

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] Windows user app to display input form + reporting?

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

[sqlite] SQL quine using with

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] sqLlite default value setting

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

Re: [sqlite] New

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] Delete From Not Working Properly

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] Question about how sqlite recovers after a power loss

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] Bug in SQLite 3.8.2

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] help needed for major SQLite problem

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] help needed for major SQLite problem

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] Transaction behaviour

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] Simple data conversion in SQLite - please help

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

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

&& 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] select only records with fields that BEGIN with a certain sub-string

-- 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: PRAGMA busy_timeout outputs the value, screws up html

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] An "unable to open database file" error that has nothing to do with opening database file

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] sqlite download for 64 bit

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] SQLite ver: 1.0.89 issue

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] Inefficient query plan in queries with multiple joins

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] Insert with multiple nested selects.

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] SQlite3 Query Format for Export

.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] query optimization

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] query optimization

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] SQLite server/file-locking scenario

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] SQL 2003 in sqlite

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] SQL 2003 in sqlite

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] Ghost index?

;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] Ghost index?

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] Is this a proper syntax?

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] sqlite database created in PHP not readable in python becomes how do i download the correct version of the python sqlite API

den URL. You can build it yourself by checking out the correct version of the fossil repositories (links at the bottom of the http://sqlite.org/download.html page). Hope this helps. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users

Re: [sqlite] multiple connection to the same DB

gt;What software or library calls are you using ?  The SQLite shell tool ?  The C >API ? > >How are the computers you are using accessing the same file ?  Are you using >access across a network ?  If so, what network protocol are you using ? > >Simon. >___ &g

Re: [sqlite] A graphical tool to handle sqlite schema change(more than ALTER TABLE)

On Wed, 18 Sep 2013 20:53:31 -0700 (PDT), niubao wrote: >Thank you very much Simon, for your detailed and very clear explanation on >this. I wonder if there is some materials, a tutorial or something, that >are dedicated to SQLite schema change for beginners? > >There seems

Re: [sqlite] A graphical tool to handle sqlite schema change(more than ALTER TABLE)

spreadsheet? > >https://code.google.com/p/sqlite-manager/ should meet your needs +1 -- 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] racing with date('now') (was: Select with dates)

ction. Perhaps that should be the difference between CURRENT_TIME and datetime('now')? just my two cents... -- 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 statement

h "n" inserts based on >one >select from the PK generating initial insert. > >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] SQLite port to RTOS

On Wed, 4 Sep 2013 10:57:44 +0530, Pratheek Prakash <prathe...@tataelxsi.co.in> wrote: > Hi Kees Nuyt, > > That was really helpful. Also I have another doubt. > Eventually I will be running sqlite integrated with other > modules in a board. That is what SQLite is made for

Re: [sqlite] SQLite port to RTOS

dule for your operating system. The Unix VFS may serve as an example. A good starting point in the documentation is: http://sqlite.org/custombuild.html >Regards >Pratheek -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users

Re: [sqlite] Inefficient covering index used for Subversion with SQLite 3.8.0

SVN init code. >This stuff can't be done by theory: there are too many >possibilities and it requires too good an understanding >of how the query planner works for non-experts. >There's no substitute for actual testing. > >Simon. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nu

Re: [sqlite] Is SQLite a DBMS?

ns the OP actually registered Probably not > but he did not > try to seek for wikipedia sqlite in google? Yes, that probably means he is young and has not learned how to do research yet. > It is just me or it is quite weird? Weirdness is common on the internet. -- Groet, Cordialement,

Re: [sqlite] Database locking Error

property of the database file. Every connection will respect it. -- 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] Difference in pragma table_info between tables and views

>I understand that reporting the pk-ness of a column is likely to be >intentionally not correct for views. Indeed. >Thomas -- 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] SQLite Input with validation and lookup

ey_list For requirements you cannot implement using the above, you may need to create additional meta data tables. -- 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] select prepared statement always returning SQLITE_DONE

_reset() end loop 1 _finalize() But perhaps I don't understand your problem? -- 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] Table name in attach'ed databases

y), but why bother? -- 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 extended API usage

egacy interface: sqlite3_get_table(). http://www.sqlite.org/c3ref/free_table.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] table format for most efficient query

the internal ROWID column, saving an integer column. Also, JOIN performance on rowindex will be better as it removes one level of indirection. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] Another 2 questions about SQLite

sary when the schema changes, and can be automatic in some versions of _prepare(). In most applications the schema is quite static. my EUR 0.02 -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@sqlite.org ht

Re: [sqlite] Getting Constraints Details

sults of PRAGMA table_info(yourtablename); -- 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] anyone know how to use ta-lib api to the sqlite database?

: The whole SQLite API is C, not C++, but it can be called from C++. Warning: I've never done any of this myself, and I don't know what kind of API ta-lib offers. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mailing list sqlit

Re: [sqlite] Updating a table from itself

pdating a table from itself > >On 6/8/2013 2:51 PM, Dave Wellman wrote: >> update t1 from (select c1,c2 from t1) as dt1 set c2 = dt1.c2 where >> t1.c1 = dt1.c2 - 1; > >update t1 set c2 = coalesce((select c2 from t1 dt1 where t1.c1 = dt1.c2 >- 1), c2); -- Groet, Cordialeme

Re: [sqlite] sqlite abnormal IO writing

odify it? Perhaps http://sqlite.org/faq.html#q19 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] A sqlite database changing the contents when I change the database name or user rights

or .etilqs . -- 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] 64bit compatibility warnings

e in the entire code base, > so that should be an easy fix. Warnings are fixed eventually ( e.g. <http://www.sqlite.org/cgi/src/info/274d2a2266> ), but with a lower priority than making sure all tests succeed.   >Alex -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _

Re: [sqlite] Performance with journal_mode = off

leave journaling enabled and do all writes > within a single transaction. I miss one test case: both journal_mode = off, and all 5764 inserts within a single transaction. Give that one a thought (and a try) and you'll understand the difference. -- Groet, Cordialement, Pozdrawiam, Regard

Re: [sqlite] import TXT file

s, for example in http://unxutils.sourceforge.net/ Note: you need both UnxUtils.zip and UnxUpdates.zip >Or is there a way I can force sqlite3 to ignore these double quotes? > >thanks > >gert -- 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] Set Mode to HTML via VBScript

FROM Booking;" >>My.html Try: sqlite3 -help for more options. -- 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] Sqlite and AS400

"iSeries Python". http://www.iseriespython.com/app/ispMain.py/Start?job=Posts==ViewSubject=LastPost=6=20=Y=598 If this is not what you are looking for, please specify your problem. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___

Re: [sqlite] Fwd: How to prevent View sqlite database structure and contents from database browsers

On Fri, 08 Feb 2013 19:46:49 +0100, Kees Nuyt <k.n...@zonnet.nl> wrote: > ... to black access ... ... to block access ... Note to self: proofread thoroughly. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt ___ sqlite-users mai

<    1   2   3   4   5   6   7   8   9   >