[sqlite] Overloading a database field

Hi everyone , I am using SQLite 2.1 database . The schema of a particular field in a table have only 40 varChars to this field . However I can overload / overfill this field to more than 50 characters or even more ! Does it takes up the space that's have not been used by other fields ?

Re: [sqlite] SQLite 3.5.* source code location?

Hi Bharath, Could anybody tell where can I get the latest sqlite3 source code for Mac OS 10.4? I'm no source code expert, but source code is generally by nature platform agnostic. So there is generally just one source code, which you can compile to suit whatever platform. So, you just

[sqlite] SQLite 3.5.* source code location?

Hello, Could anybody tell where can I get the latest sqlite3 source code for Mac OS 10.4? Regards, Bharath --- Robosoft Technologies - Come home to Technology Disclaimer: This email may contain confidential material. If you were not an intended

[sqlite] How is the best why to retrieve the key of row just insert?

Hello, How is the best why to retrieve the key of row just inserted? Is secure to use sqlite3_last_insert_rowid? In my case I have another application that is also accessing the database. Thank you for the help, Best regards, Joaquim de Campos Salles In the documentation(see bellow )

Re: [sqlite] Insert query very slow

Givernaud Omar wrote: Hello, I made a "hello world" program in order to test SQLite, but it is very slow : I am trying to set 1000 INSERT in a database. The time average is 2m30s on a AMD Athlon(TM) XP 2400+ with 1Go Ram however http://www.sqlite.org/speed.html My code

Re: [sqlite] Database file size

Do you know how I can determine programatically if the database has a lot of empty space? For example how i can determine if 30% of the data space is empty? Trey Mack wrote: > > >> I add records to database tables. Then when i delete them the database do >> not >> reduce size. I add BLOB

Re: [sqlite] Database file size

I add records to database tables. Then when i delete them the database do not reduce size. I add BLOB elements. Do you know what can be the problem? Thanks http://www.sqlite.org/lang_vacuum.html - To unsubscribe,

[sqlite] Database file size

I add records to database tables. Then when i delete them the database do not reduce size. I add BLOB elements. Do you know what can be the problem? Thanks -- View this message in context: http://www.nabble.com/Database-file-size-tf4666479.html#a13330175 Sent from the SQLite mailing list

Re: [sqlite] Detecting duplicate insert in bulk insert

Hi Renaud, You do a: - BEGIN EXCLUSIVE - INSERT many times, preferably using a precompiled statement - COMMIT (or ROLLBACK) This is extremely fast. I'm inserting 7000 records in less than a second into my database table. Olaf - Original Message - From: "Renaud HUILLET" <[EMAIL