[sqlite] Suboptimal code in createCollation()

2011-07-07 Thread Dmitry
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] Bug: PRAGMA busy_timeout outputs the value, screws up html

2013-12-24 Thread dmitry babitsky
*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

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

2011-03-20 Thread Dmitry Arefiev
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.

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

2011-12-26 Thread Dmitry Arefiev
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

[sqlite] Database is locked - again

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

[sqlite] Performance in a case of big columns number

2009-09-17 Thread Dmitry Konishchev
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)?

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

2009-09-18 Thread Konishchev Dmitry
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_ |---|-|

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

2009-09-18 Thread Konishchev Dmitry
> 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

2009-09-19 Thread Dmitry Konishchev
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_ |---|-|

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

2009-09-19 Thread Dmitry Konishchev
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

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

2013-08-13 Thread Dmitry Pashkevich
ite.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

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

2013-08-21 Thread Dmitry Pashkevich
=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

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

2013-08-21 Thread Dmitry Pashkevich
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 sqlite3_prepare_v2() > AP

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

2013-08-26 Thread Dmitry Pashkevich
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-

[sqlite] sqlite .import bug

2013-09-06 Thread dmitry babitsky
*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

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

2005-02-15 Thread Dmitry Bobrik
ase 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-field".

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

2012-01-27 Thread Dmitry Astapov
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] Reducing size

2012-09-12 Thread Dmitry Baryshev
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

Re: [sqlite] Reducing size

2012-09-12 Thread Dmitry Baryshev
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

Re: [sqlite] Reducing size

2012-09-13 Thread Dmitry Baryshev
2012/9/12 Simon Slavin <slav...@bigfraud.org> > > On 12 Sep 2012, at 8:00pm, Dmitry Baryshev <ksquirrel...@gmail.com> wrote: > > > Actually this is a dynamically loaded plugin, so compiler won't strip > > unused functions. I cannot change this behaviour. That's

Re: [sqlite] Zeroblob initialization memory allocation issue

2012-10-17 Thread Dmitry Tsinin
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; Alexander