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

[Alessandro Marzocchi]

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...
See http://www.sqlite.org/datatype3.html
Il giorno 06/mag/2013 05:05, "Igor Tandetnik"  ha
scritto:

> 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 ahead and do that - I'm not sure what that has to do with
> SQLite.
> --
> Igor Tandetnik
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SEE + CEROD

[Mohit Sindhwani]

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 someone 
with experience of this to share whether there are any gotchas that we 
should be aware of.


Best Regards,
Mohit.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Igor Tandetnik]

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 ahead and do that - I'm not sure what that has 
to do with SQLite.

--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Igor Korot]

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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Auto-Checkpoint when Transaction finishes?

[Nikolaus Rath]

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 transaction finishes.

I was wondering if there's been any news on this issue. Has it been
considered and rejected/considered and implemented/approved but not
implemented, or not yet been considered at all?

Best,

   -Nikolaus

-- 
 »Time flies like an arrow, fruit flies like a Banana.«

  PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6  02CF A9AD B7F8 AE4E 425C
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[fnoyanisi]

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, Newbie89  wrote:

> 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
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Newbie89]

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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[fnoyanisi]

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: 
> 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
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Newbie89]

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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users