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

*bug description:* Using PRAGMA busy_timeout outputs the value which in case of html output screws up the display. To be more precise, it creates an extra row/recordset with the timeout value, which is what then shows on the html page. There should be a way to say "set the pragma, but don't output

[sqlite] sqlite .import bug

*This works fine:* echo 1 | sqlite dbfile ".import '/dev/stdin' foo" But if you have any character (like a space, or newline), or sql statement in front of the '.import', sqlite gives: "Error near "." syntax error *Why it matters:* * * Because what I'm really trying to do is to import data ignor

Re: [sqlite] Literature on the information theory behind SQL(lite)?

laim the > > reduced price. > > > > -- > > D. Richard Hipp > > d...@sqlite.org > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _

Re: [sqlite] [Bug] sqlite3_finalize() *DOES NOT* return most recent evaluation error code

ep returns 101 > second step returns 1 > error message = SQL logic error or missing database > second step's reset returns 19 > error message = column x is not unique > finalize returns 0 > > which matches the output from the Lua script. > > The next version of lsqlite3 will use the recommended sqlit

[sqlite] [Bug] sqlite3_finalize() *DOES NOT* return most recent evaluation error code

ue *> =stmt:finalize() -- finalize returns OK!* *0* *> =db:errmsg() -- error message is still persisted, though* *column x is not unique* Somebody please confirm this... -- Dmitry Pashkevich ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] (sqlite >=3.7.11) Rolling back a transaction doesn't release a lock caused by pending statements

already running<http://sqlite.1065341.n5.nabble.com/BUG-sqlite3-exec-quot-BEGIN-ROLLBACK-quot-corrupts-statement-already-running-td63874.html> -- Dmitry Pashkevich ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Zeroblob initialization memory allocation issue

if we did, please point us to this. Anyway, thanks a lot. Dmitry Tsinin OS33 From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard Hipp Sent: Tuesday, October 16, 2012 4:24 PM To: General Discussion of SQLite Database Cc: Dmitry Tsinin; Dennis Davydov; Alex Osipov; Alex

Re: [sqlite] Reducing size

2012/9/12 Simon Slavin > > On 12 Sep 2012, at 8:00pm, Dmitry Baryshev wrote: > > > Actually this is a dynamically loaded plugin, so compiler won't strip > > unused functions. I cannot change this behaviour. That's why I'm asking > > about SQLITE_*

Re: [sqlite] Reducing size

2012/9/12 Simon Slavin > > On 12 Sep 2012, at 7:05pm, Rob Richardson > wrote: > > > Why are you concerned about the size of sqlite3.o? > > Or, to clarify Rob's question, modern compiler chains include only code > for routines which are referred to from main() on down. If no part of your > code

[sqlite] Reducing size

Hi. I use a sqlite database in read-only mode. The database itself contains just one table with an unique key, several strings and a double number per row: 0 'book1' 'author1' 10.00 1 'book2' 'author2' 12.05 2 'book3' 'author3' 9.35 ... I use just the following SQL commands in my application to

[sqlite] [bugreport] Comments in views can result in broken backups

ign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE a (int); CREATE VIEW b as select * from a -- pretty useless view; CREATE VIEW c as select * from b; COMMIT; As far as I was able to tell, this is not a known bug. -- Dmitry Astapov ___ sqlite-users ma

[sqlite] ANN: AnyDAC for Delphi Winter 2012 (v 5.0.5) released

Dear Sir or Madam, DA-SOFT Technologies announces the immediate availability of "AnyDAC for Delphi" v 5.0.5 Winter 2012. Version Highlights == - SQLite v 3.7.9 support; - major TADTable and Live Data Window mode optimization; - PostgreSQL v 9 support (named parameters, anonymous b

[sqlite] Suboptimal code in createCollation()

save a couple of processor cycles in cases where control doesn't pass into that "if" body. Best wishes. Dmitry. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ANN: "AnyDAC for Delphi" Spring 2011 v 4.0.7 released

Dear Sir or Madam, DA-SOFT Technologies announces the immediate availability of "AnyDAC for Delphi" Spring 2011 release v 4.0.7.1719. AnyDAC for Delphi = AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal.

Re: [sqlite] Performance in a case of big columns number

Thanks! I hope that it will work faster. If you have any links to articles describing such dark sides of SQLite or some techniques of using it such as this, I'll be very grateful if you write them here. Pavel Ivanov wrote: > Yes, you will be able to find information you need. You can store your

Re: [sqlite] Performance in a case of big columns number

Please sorry for my terrible Engilsh. :) Thanks for the answer. Yes, I know that it is bad design in the common case. But I have to use it because I have data which has following format: time | value_1 | value_2|value_ |---|-| [time

Re: [sqlite] Performance in a case of big columns number

> It'll work, but SQLite does not use a balanced tree to store the > columns for a particular record. So if you're seeking the 700th > column of a particular row, it has to look through 699 others before > it gets to it. Unless you always handle all the columns of a row > together, it'll

Re: [sqlite] Performance in a case of big columns number

Please sorry for my terrible Engilsh. :) Thanks for the answer. Yes, I know that it is bad design in the common case. But I have to use it because I have data which has following format: time | value_1 | value_2|value_ |---|-| [time_1]

[sqlite] Performance in a case of big columns number

Hello. Data in my program has such format that there is useful to place it in the database in many (thousands) columns. Please, answer me: does SQLite work more slowly when it has very big number of columns in the table (with the same total amount of data)? _

[sqlite] Database is locked - again

http://cvsview.parser.ru/cgi/viewcvs.cgi/sql/sqlite/parser3sqlite.C?rev=1.1&content-type=text/vnd.viewcvs-markup -- Best regards, Dmitry Bobrik sqlite on bcsoft dot org - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] datetime column type, how-to

e you need a human-readable date. the format is: -mm-dd hh:mm:ss like 2005-02-15 11:55:54 it will be sorted correctly with ORDER BY Unc> I will need to retrieve by date/time in proper order. i.e. "select * from Unc> 'table' ORDER BY datetime-fi