[sqlite] Banishment. Was: (no subject)

A quick policy reminder: Emails such as the one below (don't click on the link) result in immediate banishment from the mailing list. I don't know if James Brison is a real person or the nom de guerre of some robot. In either event, don't let the same fate befall you - make sure your computer

[sqlite] (no subject)

http://en.shijingsteel.com/pptlr.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Not sure how to interrupt this

I am getting back SQLITE_DONE (101) from sqlite3_step() and the statement is clearly being executed. SQL: "INSERT INTO [Scans](ScanID, Timestamp, EndTime, Result) VALUES(NULL, @Timestamp, @Timestamp, @Result);" The table has been created as: CREATE TABLE [Scans] (ScanID INTEGER NOT

Re: [sqlite] improvement to date/time documentation

On Wed, Jun 27, 2012 at 3:34 PM, wrote: > > What is also confusing (and maybe is a feature request) is that the > default JDBC format for the Xerial driver (at least) is to output a time as > "2012-07-19 09:58:18.36" which doesn't [quite] match any of the internal >

[sqlite] improvement to date/time documentation

Sorry if this is the wrong place for this. Just a quick comment that it would be good for the following documentation page about date functions to mention more specifically that the value of the fields need to be in one of the time formats: http://www.sqlite.org/lang_datefunc.html The 'Time

Re: [sqlite] SQLite Encryption Extension Performance?

On Wed, Jun 27, 2012 at 2:55 PM, Paul Vercellotti wrote: > > > Hi there, > > We are considering using the SQLite Encryption Extension in one of our > products, and are wondering what the performance characteristics of it are? > Does the encryption algorithm affect

Re: [sqlite] SQLite Encryption Extension Performance?

Hi Paul, Are you speaking of CEROD? FYI, I use to link sqlite3.c with the free wxSQLite3 encryption (AES128/256) module (http://wxcode.sourceforge.net/components/wxsqlite3). I didn't notice any significant slowing down (3-4% max.), but of course there is no compression involved... Hope this

[sqlite] SQLite Encryption Extension Performance?

Hi there, We are considering using the SQLite Encryption Extension in one of our products, and are wondering what the performance characteristics of it are?   Does the encryption algorithm affect performance?   Any stats on this you might have would be useful. Thanks! -Paul

Re: [sqlite] SQLite only supports TYPE_FORWARD_ONLY cursors

On Wed, 27 Jun 2012 07:10:49 -0400, gizu tseng wrote: > Hello, > I am porting my Java applications from Oracle Lite to SQLite and > getting those error message: “SQLite only supports TYPE_FORWARD_ONLY > cursors”. > I’d like to know if there is any (updated) SQLite JDBC

Re: [sqlite] sqlite time is 2 hours to late

And I should also add...sqlite doesn't respect timezones for past/future dates. So...you may want to consider storing both UTC and localtime and then you can do whatever you want by selecting the appropriate field. That way historical reports can be accurate with localtime. Or you can

Re: [sqlite] sqlite time is 2 hours to late

> UTC is "the right time." If you're doing anything with dates and > times I would STRONGLY recommend that all recorded times are in UTC. Jay is right. I've been bitten by storing local times before. Even if your users are in the same time zone, that time zone shifts with day light savings.

Re: [sqlite] sqlite time is 2 hours to late

Kinda' depend on what exactly you want to do. If you want your application to always use local time no matter where it's run: select('now','localtime'); If you want to know how far off of UTC you are do this: select round((julianday('now','localtime')-julianday('now'))*24); In my case this

Re: [sqlite] Example database with lots of "types"?

On 27 Jun 2012, at 5:00pm, Maury Markowitz wrote: > I'm working on getting the Mac version of the SQLite ODCB connector fully > functional. I'm having some problems getting examples of lots of different > data types - for instance, my northwind copy has a decimal

Re: [sqlite] sqlite time is 2 hours to late

Fully agree with you, Jay. -> SQLite NUL "select datetime('now','localtime');" E. On Wed, Jun 27, 2012, at 10:55, Jay A. Kreibich wrote: > On Wed, Jun 27, 2012 at 05:45:41PM +0200, deltagam...@gmx.net scratched on > the wall: > > Am 27.06.2012 17:40, schrieb Jay A. Kreibich: > > >On Wed, Jun

[sqlite] Example database with lots of "types"?

I'm working on getting the Mac version of the SQLite ODCB connector fully functional. I'm having some problems getting examples of lots of different data types - for instance, my northwind copy has a decimal stored as a varchar. Does anyone have a small test DB they would be willing to part

Re: [sqlite] sqlite time is 2 hours to late

On Wed, Jun 27, 2012 at 05:45:41PM +0200, deltagam...@gmx.net scratched on the wall: > Am 27.06.2012 17:40, schrieb Jay A. Kreibich: > >On Wed, Jun 27, 2012 at 05:37:55PM +0200, deltagam...@gmx.net scratched on > >the wall: > > > >>Hello, > >> > >>>sqlite3 event.db "select datetime('now')"; >

Re: [sqlite] sqlite time is 2 hours to late

Am 27.06.2012 17:40, schrieb Jay A. Kreibich: On Wed, Jun 27, 2012 at 05:37:55PM +0200, deltagam...@gmx.net scratched on the wall: Hello, sqlite3 event.db "select datetime('now')"; gives me a time that is 2 hours too late ( 2012-06-27 15:33:13) than my system time ( win 7 ) 17::33:13

Re: [sqlite] sqlite time is 2 hours to late

On Wed, Jun 27, 2012 at 05:37:55PM +0200, deltagam...@gmx.net scratched on the wall: > Hello, > > >sqlite3 event.db "select datetime('now')"; > gives me a time that is 2 hours too late ( 2012-06-27 15:33:13) > than my system time ( win 7 ) 17::33:13 > > How can this be fixed ? Move two

[sqlite] sqlite time is 2 hours to late

Hello, >sqlite3 event.db "select datetime('now')"; gives me a time that is 2 hours too late ( 2012-06-27 15:33:13) than my system time ( win 7 ) 17::33:13 How can this be fixed ? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite only supports TYPE_FORWARD_ONLY cursors

> > gizu tseng wrote: > > I am porting my Java applications from Oracle Lite to SQLite and > > getting those error message: "SQLite only supports TYPE_FORWARD_ONLY > > cursors". > > I'd like to know if there is any (updated) SQLite JDBC driver that > > supports the

Re: [sqlite] SQLite only supports TYPE_FORWARD_ONLY cursors

gizu tseng wrote: > I am porting my Java applications from Oracle Lite to SQLite and > getting those error message: “SQLite only supports TYPE_FORWARD_ONLY > cursors”. > I’d like to know if there is any (updated) SQLite JDBC driver that > supports the TYPE_SCROLL_INSENSITIVE

[sqlite] SQLite only supports TYPE_FORWARD_ONLY cursors

Hello, I am porting my Java applications from Oracle Lite to SQLite and getting those error message: “SQLite only supports TYPE_FORWARD_ONLY cursors”. I’d like to know if there is any (updated) SQLite JDBC driver that supports the TYPE_SCROLL_INSENSITIVE cursors? Thanks you.

Re: [sqlite] I consider this a bug. Anyone else?

When seeking additional pain along these lines, your attention is drawn to sqlitejdbc. I did get it to compile and pass its test suite; actually integrating it with a project, not so much. On Tue, Jun 26, 2012 at 5:39 PM, E. Timothy Uy wrote: > " 40-80 hours digging deep into

Re: [sqlite] convert CString for statement

If you are compiling for Unicode, your CString has a LPCWSTR (const wchar_t*) operator. In that case use sqlite3_bind_text16. If you're not using Unicode, then there is a LPCSTR (const char*) operator that will let you use sqlite3_bind_text directly like Alessandro shows. Doug -Original

Re: [sqlite] convert CString for statement

I have no way to test but i think a call like rc = sqlite3_bind_text(stmt, 1, (LPCTSTR)likeexp, -1, SQLITE_TRANSIENT ); would work 2012/6/26 deltagam...@gmx.net > Hello I have as input parameter > > CString likeexp > > but I think

[sqlite] Load SQLite from InputStream in Java as ReadOnly

Hello everyone, I'm new to SQLite as well as to this list. I'm writing because I was planning on using SQLite for a personal -but public- project that I wanted to make available through Google App Engine. It is basically a SQLite to CSV converter and a SQLite to VCard converter. In other words, I