See subject. Thanks!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[[
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.
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};
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..
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
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
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,
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
8 matches
Mail list logo