Re: [sqlite] Is there a way to select a precision?

If what you want is a way to store floating point numbers with a precision other than double (8 bytes) to decrease space usage or to get more precisione the answer is no. The only native data types for sqlite are integer (which can simulate bools), string, double and blob. Plus of course NULL...

[sqlite] SEE + CEROD

Hi Guys, We already have a license for CEROD and are now contemplating getting a license for SEE to use within our products. I notice that both products are separately provided as amalgamation sqlite3.c files. Is it possible to use these two together in the same system? Just looking for

Re: [sqlite] Is there a way to select a precision?

On 5/5/2013 8:24 PM, Igor Korot wrote: Is there a way to select a precision either on the call to sqlite3_bind_double() or before it? What do you mean, select precision? The double value you pass to sqlite3_bind_double() will be used as is. Are you saying you want to round it first? Then go

[sqlite] Is there a way to select a precision?

Hi, ALL, Is there a way to select a precision either on the call to sqlite3_bind_double() or before it? Other than the call to sprintf() Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Auto-Checkpoint when Transaction finishes?

Hello, About two years I posted an example that results in unbounded growth of the WAL file (http://news.gmane.org/find-root.php?message_id=%3c87r57xrq1m.fsf%40inspiron.ap.columbia.edu%3e). At that point, the conclusion was that it might be worth to consider auto-checkpointing when a read

Re: [sqlite] How to read log file format into sqlite database?

To read txt, use fread() or fgets() . This is the most convenient answer I think. It is up to your programming skills to read the file line by line and parse each line according to your needs. Here is an example https://github.com/fnoyanisi/sqlite3_capi_extensions On 05/05/2013, at 6:20 PM,

Re: [sqlite] How to read log file format into sqlite database?

let say is .txt file -- View this message in context: http://sqlite.1065341.n5.nabble.com/How-to-read-log-file-format-into-sqlite-database-tp68676p68678.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list

Re: [sqlite] How to read log file format into sqlite database?

What is your format? Please ask questions that make sense! On 05/05/2013, at 6:09 PM, Newbie89 wrote: > any example/tutorial?thanks. > > > > -- > View this message in context: >

[sqlite] How to read log file format into sqlite database?

any example/tutorial?thanks. -- View this message in context: http://sqlite.1065341.n5.nabble.com/How-to-read-log-file-format-into-sqlite-database-tp68676.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list