[sqlite] How to build sqlite4? Which branches are expected to build?

2012-08-07 Thread Nico Williams
See subject. Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] 3rd Call For Papers, 19th Annual Tcl/Tk Conference 2012

2012-08-07 Thread Andreas Kupries
[[ Get your papers, WIPs and posters in. (We have an exhibition hall with 25 gesture-controlled screens to show the latter two on). The deadline for abstracts and proposals is three weeks away. ]] [[ Notes: Colin Walker of F5 is confirmed as our Keynote speaker.

Re: [sqlite] C# Dynamic data type

2012-08-07 Thread Black, Michael (IS)
You can use sscanf to determine data type...I've done it before using a method that's not obvious... You parse from most restrictive to least restrictive format like this...this will accept any valid float format including scientific notation. #include enum {UNKNOWN, FLOAT, INT, STRING};

[sqlite] C# Dynamic data type

2012-08-07 Thread Adam DeVita
Good day, I've been reading a bit of conflicted stuff online in terms of data type. The most basic question, in C#, is can you easily determine the data type of the Nth entry in a column. {Ex: Create table A( x TEXT, y ) ... a few inserts, binding a float, then a string, then an int into y..

Re: [sqlite] Suggestions for approximate date

2012-08-07 Thread Black, Michael (IS)
I'd vote for the date-range as that can be indexed and result in fast retrieval. The separate column for accuracy would be a computed range and not indexable. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information

[sqlite] Suggestions for approximate date

2012-08-07 Thread Oliver Schneider
Hello, I have a decision to make about how to store dates that may not be entirely accurate inside an SQLite DB. There are two options I came up with: 1. store "exact" date plus (in separate column) value for accuracy 2. store date range corresponding to original accuracy The accuracy can be

[sqlite] Fw: Fw: Fw: A question on sqlite processing

2012-08-07 Thread u okafor
Dear sirs, My group is working with SQLITE Version 3.7 . .and the project has to do with transformation of applications to run on a Bare PC. On a CREATE TABLE, our traversal, in terms of opcodes, inside sqlite3VdbeExec() is something like 1, 22, 25, 1, 23, 1a, 7, 24, 7, 24, 62, 27, 36, a, 37,

Re: [sqlite] How to build a new sqlite3.dylib?

2012-08-07 Thread Clive Hayward
Tobias, Heres how you can make your own shared library under Mac OS X. Download http://www.sqlite.org/download.html/sqlite-amalgamation-3071300.zip # In the terminal export LD_LIBRARY_PATH=. # Make the library call it libsqlite3_mybuild.dylib gcc -o libsqlite3_mybuild.dylib sqlite3.c