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] 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] 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] 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] 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] 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] 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] 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] Access Temp Tables/Views in background thread

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?

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

=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

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

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?

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?

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 ?

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()

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

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?

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

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

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

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

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

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

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

[sqlite] AUTOINC vs. UUIDs

_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

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?

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

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

[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] 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

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

[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] 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

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

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

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

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

>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

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

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

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

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

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

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

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

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

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

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

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

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

,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)

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

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?

: 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

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.

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

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

Re: [sqlite] can we do recovery for certain time?

replayplease help me. Reading the documentation at http://www.sqlite.org/docs.html will give you more insight. -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

  1   2   3   4   5   6   7   8   9   >