Re: [sqlite] JDBC driver experience

This writing is 4/22/2018. I have been playing with the latest connect/j for android java downloaded from Oracle's web site and have had no luck getting it to connect to the latest Community version of MySQL on Windows 10 using Oracles example java code... then I found an example that someone

Re: [sqlite] JDBC driver experience

1. I use an old version of xerial with Aejaks for an on-line voting system. 2. I started around 2010, and updated only once, in order to get the backup command (greatly simplifying my process). 3. My only issue is paranoia about breaking something, which keeps me from doing further updates. 4.

Re: [sqlite] JDBC driver experience

no On Wed, Apr 18, 2018 at 8:34 PM, Richard Hipp wrote: > Are you using SQLite with JDBC? If so, can you please answer a few > questions below? > > You can post on this mailing list or send your reply directly to me. > > 1. Which JDBC are you using? > 2. For how long have you

Re: [sqlite] JDBC driver experience

Hi, Le mer. 18 avr. 2018 à 21:34, Richard Hipp a écrit : > Are you using SQLite with JDBC? If so, can you please answer a few > questions below? > > You can post on this mailing list or send your reply directly to me. > > 1. Which JDBC are you using? I am using xerial and

Re: [sqlite] JDBC driver experience

On Thu, 19 Apr 2018 09:37:20 -0700 "dmp" wrote: > Currently I trying to complete a plugin for Ajqvue > that transfers data from others databases to SQLite. Hi, I made an odbc virtual table to achive this. It's closed source but the ¿difficulty? to develop one

Re: [sqlite] JDBC driver experience

> Are you using SQLite with JDBC? If so, can you please answer a few > questions below? > You can post on this mailing list or send your reply directly to me. 1. Which JDBC are you using? Current Xerial SQLite JDBC https://github.com/xerial/sqlite-jdbc Others that I have tried are a

Re: [sqlite] JDBC driver experience

1. Xerial 2. A year or so, relatively heavily. 3. * MAX_MMAP_SIZE is too small by a few hundred megabytes. It's safe to set to around a terabyte. * No way to effectively use multiple threads, even on a read-only mmap'd database. * Planner sometimes misses plans - does it need better STAT

Re: [sqlite] JDBC driver experience

1. Xerial 2. Couple years? 3. None. But I am just a dumb user. I use JetBrains IDE's (RubyMine, Rider, Datagrip). The IDE's provide direct access to the datasource for looking at the db, manipulating data, manipulating tables. That sort of stuff. Never once have I had an issue with the driver

[sqlite] JDBC driver experience

Are you using SQLite with JDBC? If so, can you please answer a few questions below? You can post on this mailing list or send your reply directly to me. 1. Which JDBC are you using? 2. For how long have you been using it? 3. What issues you had with this driver? 4. What advise do you have for