Dan... Yes the varint!

--- On Mon, 5/4/09, Dan <danielk1...@gmail.com> wrote:

> From: Dan <danielk1...@gmail.com>
> Subject: Re: [sqlite] OT: how best to convert sqlite3_int64 to and from 
> string in a cross platform fashion?
> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
> Date: Monday, May 4, 2009, 11:52 PM
> 
> On May 4, 2009, at 10:14 PM, Ken wrote:
> 
> >
> > You could just pass the sqlite3_int64 value. It is
> portable between  
> > systems. Search through the sqlite3 code and there are
> routines that  
> > do the conversions from the sqlite3_int64 to a native
> int64 type.  
> > They basically perform bit shifting and will be much
> faster than the  
> > string conversions.
> 
> 
> You're thinking of the varint format used in the
> file-format:
> 
>    http://www.sqlite.org/fileformat.html#varint_format
> 
> sqlite3_int64 is just a typdef of int64_t on most
> platforms.
> 
> Dan.
> 
> 
> 
> 
> >
> >
> > HTH,
> > Ken
> >
> > --- On Sun, 5/3/09, Sam Carleton <scarle...@miltonstreet.com>
> wrote:
> >
> >> From: Sam Carleton <scarle...@miltonstreet.com>
> >> Subject: [sqlite] OT: how best to convert
> sqlite3_int64 to and from  
> >> string in a cross platform fashion?
> >> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
> >> Date: Sunday, May 3, 2009, 4:21 PM
> >> I am current developing a system only
> >> on Windows, but I do plan to port it
> >> to OSX someday.  I am passing ID's as strings
> to keep
> >> maximum flexibility
> >> between databases and the existing system. 
> So how do
> >> I convert a
> >> sqlite3_int64 to a string and a string to a
> sqlite3_int64
> >> in a cross
> >> platform fashion?
> >>
> >> Sam
> >> _______________________________________________
> >> 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-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

Reply via email to