Re: [sqlite] Limit to database and/or blob size on Mac/Windows?

On 17/04/2009 12:01 AM, Vinnie wrote: > Dear Group: > > I've done some calculations and its a fairly likely scenario that my users > will end up with sqlite databases that are over 1 gigabyte in size, in some > cases 4 gigabytes. An upper limit on the number of rows in a table could be > as hig

Re: [sqlite] SQLite-amalgamation changes every few hours

D. Richard Hipp schrieb: > > The mingw_cross_env verifies all downloads via their SHA-1 checksum. > > However, the SQLite source package changes every few hours. [...] > > The amalgamations packages changed once after the release announcement > because the first package we put up was a defectiv

Re: [sqlite] SQLite-amalgamation changes every few hours

Hello! On Friday 17 April 2009 00:09:21 D. Richard Hipp wrote: > If you have seen the amalgamation SHA1 sums change more than one time, > that is an indication of unauthorized hacking of the SQLite website. > Please let us know. But if you saw just this one change, then please > discard the

Re: [sqlite] SQLite-amalgamation changes every few hours

On Apr 16, 2009, at 3:58 PM, Volker Grabsch wrote: > Dear SQLite authors, > > I'd like to include SQLite in my MinGW cross compiling environment > (http://www.profv.de/mingw_cross_env/), but I ran into some trouble. > > The mingw_cross_env verifies all downloads via their SHA-1 checksum. > Howeve

Re: [sqlite] Changes to closed tickets.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Noah Hart wrote: > If I append a report to a closed ticket, will developers look at it, or > should I open a new ticket? All changes show up in the timeline, so it will be clear that changes have been made: http://www.sqlite.org/cvstrac/timeline R

[sqlite] SQLite-amalgamation changes every few hours

Dear SQLite authors, I'd like to include SQLite in my MinGW cross compiling environment (http://www.profv.de/mingw_cross_env/), but I ran into some trouble. The mingw_cross_env verifies all downloads via their SHA-1 checksum. However, the SQLite source package changes every few hours. Is there an

Re: [sqlite] How to get PRIMARY KEY of newly INSERT INTO record

> Cool! That worked. The VB6 wrapper has a LastInsertAutoID that I never paid > attention / saw before. Be sure that it's doing what you think it is. If it's a general purpose wrapper, then it might not. If it's a SQLite specific wrapper, it might, but even if it's wired up correctly, you have t

Re: [sqlite] How to get PRIMARY KEY of newly INSERT INTO record

Cool! That worked. The VB6 wrapper has a LastInsertAutoID that I never paid attention / saw before. I will use the other SQL statement that you mentioned for the C/C++ stuff. Awesome! Thanks again :-), Sarah -- View this message in context: http://www.nabble.com/How-to-get-PRIMARY-KEY-of-newl

Re: [sqlite] Bus Error

On Apr 16, 2009, at 2:40 PM, Christopher Bare wrote: > Hi, > > Here's a head's up on an obscure error I ran into. Maybe documenting > it will help the developers or a future victim: Thanks. But this has already been documented at ticket #3530 (http://www.sqlite.org/cvstrac/tktview?tn=3530 ) a

[sqlite] Bus Error

Hi, Here's a head's up on an obscure error I ran into. Maybe documenting it will help the developers or a future victim: I have a couple tables like this: sqlite> .schema tracks CREATE TABLE tracks ( uuid text primary key not null, name text not null, type text not null,

Re: [sqlite] How to get PRIMARY KEY of newly INSERT INTO record

Sarah M. Weinberger wrote: > QUESTION: How do I get the primary key of the newly inserted record? sqlite3_last_insert_rowid select last_insert_rowid(); Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] How to get PRIMARY KEY of newly INSERT INTO record

>      'Create the SQL command. >      strSQLCommand = "INSERT INTO " + strDBTable + " VALUES (null" + > strUpdate + ");" http://www.sqlite.org/lang_corefunc.html Use last_insert_rowid() as a second statement in your query: 'Create the SQL command. strSQLCommand = "INSERT INTO " + strDBTable +

[sqlite] How to get PRIMARY KEY of newly INSERT INTO record

Hi, I am using both VB6 and C/C++ to interface to a SQLITE3 database. If I execute a command that inserts a new record, such as: 'Set the various columns strUpdate = ", dataCol2, dataCol3, ..., dataColN" 'Create the SQL command. strSQLCommand = "INSERT INTO " + strDBTabl

Re: [sqlite] SQLite complains about invalid column name but the column exists in the table

On Apr 16, 2009, at 12:46 PM, Arthur Skowronek wrote: > Hello, > I have a problem again with the same database as > before with the segfault bug. > > I can't insert any rows into the userMailBox table with > this query: > > INSERT INTO userMailBox ( userID, senderNickID, isSystem, > messageSubjec

[sqlite] SQLite complains about invalid column name but the column exists in the table

Hello, I have a problem again with the same database as before with the segfault bug. I can't insert any rows into the userMailBox table with this query: INSERT INTO userMailBox ( userID, senderNickID, isSystem, messageSubject, messageBody ) VALUES ( 0, -1, 1, "This is your new mailbox", "Message

[sqlite] Changes to closed tickets.

General question: If I append a report to a closed ticket, will developers look at it, or should I open a new ticket? For example: Ticket #3802 was closed with "Unable to reproduce this problem" I've added new information to allow the developers to reproduce. Will it be looked at, or should

Re: [sqlite] using wstring

On Apr 16, 2009, at 6:44 AM, galeazzi-at-korg.it |sqlite| wrote: > I tried to use (const char*)sQuery.c_str() but it doesn't work. Any > ideas? That won't work because std::wstring.c_str() returns wchar_t* not char*. One way would be to convert your std::wstring to an std::string in UTF-8

Re: [sqlite] Corruption of incremental_vacuum databases

Hello, I have expected at least some reply. Oh well, new the corruption has happened again (on another different machine) and I have saved the database files. One of the corrupted files is available at http://www.emclient.com/temp/folders.zip. I'd be glad for any help or at least confirmation that

Re: [sqlite] Need help with the SQL statement.

Thanks a ton Igor! It worked. Your help is greatly appreciated. Thanks, JP From: Igor Tandetnik To: sqlite-users@sqlite.org Sent: Thursday, April 16, 2009 4:52:28 AM Subject: Re: [sqlite] Need help with the SQL statement. "Joanne Pham" wrote in message news:3

Re: [sqlite] Limit to database and/or blob size on Mac/Windows?

Vinnie wrote: > . > > Is there a limit to the database size on Windows or Macintosh? > > Does the following help? http://sqlite.org/limits.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listi

[sqlite] Limit to database and/or blob size on Mac/Windows?

Dear Group: I've done some calculations and its a fairly likely scenario that my users will end up with sqlite databases that are over 1 gigabyte in size, in some cases 4 gigabytes. An upper limit on the number of rows in a table could be as high as 100,000 (yeah that not very high). There are

Re: [sqlite] using wstring

wrote in message news:20090416141406.euzgo2r52i00o...@webmail.korg.it > I cannot use parameterized queries because the queries are more > complex than the simple one that I wrote I'm not sure how your conclusion follows from the premise. You can use parameters with any query, no matter how compl

Re: [sqlite] using wstring

I cannot use parameterized queries because the queries are more complex than the simple one that I wrote, furthermore I've to use sqlite3_get_table Citando Igor Tandetnik : > wrote in message > news:20090416124428.h5zi6xji5h5wk...@webmail.korg.it >> I'm currently working with a framework whic

Re: [sqlite] using wstring

I cannot use parameterized queries because the queries are more complex than the simple one that I wrote, I've sqlite3_get_table Citando Igor Tandetnik : > wrote in message > news:20090416124428.h5zi6xji5h5wk...@webmail.korg.it >> I'm currently working with a framework which uses wstring, how

Re: [sqlite] using wstring

wrote in message news:20090416124428.h5zi6xji5h5wk...@webmail.korg.it > I'm currently working with a framework which uses wstring, how can I > dynamically create queries like this: > std::wstring sQuery = L"SELECT * FROM Table WHERE Tilte = '"; > sQuery += title; //it's a wstring > sQuery += "'" >

Re: [sqlite] Need help with the SQL statement.

"Joanne Pham" wrote in message news:348376.69121...@web90302.mail.mud.yahoo.com > 20657220 is number of minutes in GMT time zone. > So we need to convert to second by 20657220 *60. > select datetime(20657220*60, 'unixepoch','localtime' ); > will be 2009-04-11 00:00:00 In this case, this should wo

Re: [sqlite] Mismatched columns in union can repeatably crash 2.6.10

2009/4/16 D. Richard Hipp > > On Apr 15, 2009, at 4:38 PM, Tom Sillence wrote: > > > I don't have all that much time to research whether this is a known > > issue. > > The following query crashes 2.6.10 every time, on linux and windows: > > > > create table crash(a,b); insert into crash select >

[sqlite] using wstring

I'm currently working with a framework which uses wstring, how can I dynamically create queries like this: std::wstring sQuery = L”SELECT * FROM Table WHERE Tilte = '”; sQuery += title; //it's a wstring sQuery += “'” I tried to use (const char*)sQuery.c_str() but it doesn't work. Any ideas? ___

Re: [sqlite] fragmentation, overflow pages

On 16/04/2009 5:47 PM, Martin Pfeifle wrote: > Hi, > we store proprietary organized data in blobs within an sqlite database. > Assume you have a table mydata(id, attr1, attr2, blob). > The page size of the database is 1k. This is the *default* page size. You can change it before you first put da

[sqlite] fragmentation, overflow pages

Hi, we store proprietary organized data in blobs within an sqlite database. Assume you have a table mydata(id, attr1, attr2, blob). The page size of the database is 1k. If you now store blobs in your table which are larger than 1k, sqlite uses overflow pages and the content of the blobs is distr