Re: [sqlite] SQLite Android Bindings: how difficult to add LOCALIZED back?

On 01/11/2015 01:55 PM, Philip Warner wrote: On 9/01/2015 5:00 PM, Dan Kennedy wrote: On 01/08/2015 07:48 AM, Philip Warner wrote: How difficult would it be to add LOCALIZED collation support? I'm guessing that the fact it's not there means it's non-trivial, but I was hoping otherwise...

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

On 11/10/2015 08:41 PM, Richard Hipp wrote: > http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/ Congratulations! When SQLite is the spoon, will they give us Linux binary compatibility for the fork? I wonder what the knife will be ;-) -- Christian Werner

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

On 11/12/2015 03:44 PM, James K. Lowden wrote: > Fork? Isn't that what CreateProcess is for? I think not. That's a lonesome chopstick. -- Christian Werner

[sqlite] Documentation error in async_cond_wait

** Another thread is allowed to call async_cond_wait() while there is ** already a thread waiting on the condition variable. However, only ** one thread will be made runnable for one async_cond_signal() call ** on the condition variable. -- Christian Werner

[sqlite] SQLITE_CANTOPEN on Android

On 04/22/2016 03:46 PM, Richard Hipp wrote: > Why isn't /var/tmp or /tmp usable on Android? There ain't no "/var/tmp" nor "/tmp" on droids. Best of all worst alternatives is to use the application's own directory or better the subdir "cache" therein. Best, Christian

[sqlite] SQLITE_CANTOPEN on Android

On 04/23/2016 02:10 PM, Richard Hipp wrote: > Is there a well-defined way to find the name of the application's own > directory? The SDL2 library uses this approach http://www.androwish.org/index.html/artifact/f90b192eadfe588218283717932d35528d84c715?txt=1=1637-1682 i.e. calls

[sqlite] ANN: SQLiteODBC Driver 0.76

Version 0.76 of the SQLiteODBC Driver is ready for download from http://www.ch-werner.de/sqliteodbc The Win32 installer is build with SQLite 3.5.1 and 2.8.17. Enjoy, Christian - To unsubscribe, send email to [EMAIL

Re: [sqlite] Compiling Problem With SQLite 3.5.4

[EMAIL PROTECTED] wrote: > ... > The warnings all have to do with the fact that you are > compiling on a machine with 64-bit pointers and 32-bit > integers. The warnings are all harmless and the code > works as intended as long as > > sizeof(int) <= sizeof(void*) > > Perhaps a reader can

Re: [sqlite] Compiling Problem With SQLite 3.5.4

[EMAIL PROTECTED] wrote: > > Christian Werner <[EMAIL PROTECTED]> wrote: > > > > What about using the ptrdiff_t type in those places instead. > > > > Is ptrdiff_t implemented on all C compiler environments that > SQLite builds on? I'm afraid not, thu

Re: [sqlite] Compiling Problem With SQLite 3.5.4

Following patch applied to the CVS version compiled w/o warnings on a CentOS 5 x86_64 box. But I didn't run the test yet ... and autoconf logic regarding availability of ptrdiff_t is missing, too. Index: src/func.c === RCS file:

[sqlite] ANN: SQLite ODBC driver version 0.77 released

Dear all, version 0.77 of the SQLite ODBC driver is available for download from http://www.ch-werner.de/sqliteodbc It's Windows one-click installer is built with SQLite 3.5.4 and 2.8.17. There were two major bug fixes with respect to wide-char parameter binding and wide-char data retrieval,

[sqlite] [ANN] SQLite ODBC driver version 0.68

Version 0.68 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc It fixes some more bugs mainly in the SQLite 3.x version of the driver. Enjoy, Christian

[sqlite] [ANN] SQLite ODBC driver version 0.70

Version 0.70 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc The Win32 installer now is made with SQLite 3.3.7. Enjoy, Christian - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Problem using loadable extension mechanism.

jima wrote: > ... > And then I go, no problems building. I have sqlite built with this > feature I guess. > > But the thing is that I cannot make it to work. I prepared a c file > following the template given in the wiki. I generated a .so using: > > gcc -I/path_to_sqlite-3.3.7/src -c -o

Re: [sqlite] Problem using loadable extension mechanism.

jima wrote: > > Thanks for the advice but it would not work either. I just tried with the > flags you mentioned at compile time and full path when loading. > > Do you know if I have to enclose that full path in quotes or something at > load time? like... > > ..load '/path/Extension.so' > > ? >

Re: [sqlite] Problem using loadable extension mechanism.

jima wrote: > > Hi, > > I build **without** -DSQLITE_OMIT_LOAD_EXTENSION > > I do ldd on sqlite3 and I get > > libdl.so.2 => /lib/libdl.so.2 (0x00402000) > > but I cannot load my Extension.so > > Do Extension.c has to include sqlite3.h ? > Presently I am only including sqlite3ext.h.

[sqlite] ANN: SQLite ODBC driver 0.71

Howdy! Release 0.71 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc (Main page) http://www.ch-werner.de/sqliteodbc/sqliteodbc.exe (Win32 Installer) http://www.ch-werner.de/sqliteodbc/sqliteodbc-0.71.tar.gz (Sources) The most important changes are: -

Re: [sqlite] SQLite JSON interface?

Michael Ruck wrote: > > Hi, > > Is there a JSON interface for SQLite (in C/C++)? Any GPL/LGPL compatible > license or public domain would do. Someone must have written something like > it. I need to export a set of tables to JSON .js files to serve on a > webserver, the files are generated

[sqlite] ANN: SQLiteODBC Driver 0.72

Version 0.72 of the SQLiteODBC Driver is ready for download from http://www.ch-werner.de/sqliteodbc It now supports loadable extensions as of SQLite >= 3.3.7 in the form of a DSN option. The one-click Win32 installer is based on SQLite 3.3.12 and contains the FTS1/FTS2 extensions and the

Re: [sqlite] ANN: SQLiteODBC Driver 0.72

Joe Wilson wrote: > Nice job on the new driver. > > The new DSN parameter LoadExt=module1.dll,module2.dll for dynamically > loadable sqlite extension modules is particularly useful. > > The SQLite+TCC extension is very cool. Thank you, Joe! If only I had added that patch to sqlite+tcc.c

Re: [sqlite] ANN: SQLiteODBC Driver 0.72

Joe Wilson wrote: > > Hi Christian, > > I'm not sure what this patch to SQLite 3.3.12 does. > Is it fixing a bug or extending SQLite for use in your ODBC driver? > Should a ticket be created for it in SQLite CVSTrac? I've already created a low priority ticket for it, see

[sqlite] ANN: SQLite ODBC Driver 0.73

Hi all, release 0.73 of the SQLite ODBC driver is available for download from http://www.ch-werner.de/sqliteodbc >From the change log: * update to SQLite 3.3.13 * SQLGetInfo(SQL_OWNER_TERM) now is empty string * fixed bug in Win32 version concerning SQLDriverConnect() * added -L/-l/-I/-i

Re: [sqlite] ANN: SQLite ODBC Driver 0.73

Noah Hart wrote: > > Hello Christian, > > I tried your odbc driver, and it works pretty well, but does not handle > Unicode at all. > > I have a "dictionary" application with two columns, first being English, > second being Punjab (stored in Unicode) > For example, simple table with > EN_WORD

Re: [sqlite] Last ID from Primary Key through ODBC

Dan Kennedy wrote: > > On Sat, 2007-03-03 at 19:18 -0500, Mitchell Vincent wrote: > > I found the nifty ODBC driver for SQLite and have been trying to use > > it to replace a 2.8 SQlite implementation in some desktop software. > > It's working very well except for a rather large problem of not

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

Mitchell Vincent wrote: > > I have an old SQLite 2.8 database that shared it's schema with > PostgreSQL. One of the nifty things about PostgreSQL (that admittedly > has me spoiled) is the ability to just say "varchar" without any > length specifier. > > Specifying "varchar" in SQLite works great

Re: [sqlite] Accented characters and ODBC

Greg Bryant wrote: > > Not sure if ODBC questions belong here, feel free to point me to a better > forum. > > I'm using current SQLite (3.7.2) via a visual c++ app. We're connecting a > sqlite3 database via ODBC (driver from , also current version - 0.87). If I > do either an insert or update

Re: [sqlite] export to SQL insert statements with column names

[EMAIL PROTECTED] wrote: > > Hi, > Is there a way to export/dump SQLite data into INSERT statements which > also have column names? > > As of now, a sqlite dump looks like this > > INSERT INTO "ric_tb_language" VALUES('ENG','English'); > INSERT INTO "ric_tb_language" VALUES('SPN','Spanish'); >

Re: [sqlite] ODBC driver C source file includes a header which was notshipped

"Abshagen, Martin RD-AS2" wrote: > > Hi, > > am trying to use the Sqlite3 ODBC driver for C, provided by Christian Werner > (http://www.ch-werner.de/sqliteodbc/, product sqliteodbc-0.77-1.src.rpm). > If _WIN32 is defined, sqlite3odbc.c includes a "r

Re: [sqlite] SQLite.Exception: not authorized (to load a shared librarywith SQLite Java Wrapper/JDBC Driver)

Bejay Bamboo wrote: > > Hello, > i'm trying to load new SQL functions from a shared library with the > help of the SQLite Java > Wrapper/JDBC Driver (http://www.ch-werner.de/javasqlite). I'm trying > > java -cp :. -Djava.library.path=/tmp/javasqlite-20090213/.libs > SQLite.Shell db "select >

Re: [sqlite] ResultSetMetaData with javasqlite

Justin Deoliveira wrote: Justin, > I have ran into an issue while using the javasqlite jdbc wrapper.The > issue can be illustrated with the following code: > ... you're right, I've verified that behaviour with SQLite 3.x databases. The problem cannot be observed with SQLite 2.x

Re: [sqlite] ResultSetMetaData with javasqlite

Justin Deoliveira wrote: Hi Justin, > Thanks for the quick response. I am not sure if this will be of any help > or not but I wrote this (very crude) patch to get around the problem: > > http://files.opengeo.org/sqlite_jni.c.patch > > ... Based on your patch there's now a improved version in

Re: [sqlite] Port SQLite to VxWorks

ÕÅÊÀÎÅ wrote: > > Hi, all. I am new to SQLite database and encountered a big problem. I intend > to port SQLite to VxWorks OS and don't really know how. When directly > compiled the source code downloaded from the official site in VxWorks' IDE > Tornado, I kept receiving messages of certain

Re: [sqlite] SQLite Java Wrapper?

majed chatti wrote: > > I tried to use the SQLite Java Wrapper wich I > download froh here http://www.ch-werner.de/javasqlite/ > I extract it > I do > > $./configure > $make > > but I have this errors > Please try out the new version from the above mentioned website. It should now

Re: [sqlite] OT: patch for SQLite ODBC

Jarl Friis wrote: > > How about just setting > PRAGMA short_column_names = off > PRAGMA full_column_names = on > withing SQLColAttribute() and SQLColAttributes() and then, before > returning from the function(s), setting it back to > PRAGMA short_column_names = on > PRAGMA full_column_names = off

[sqlite] [ANN] SQLite ODBC driver version 0.67

Version 0.67 of the SQLite ODBC driver is ready for download from http://www.ch-werner.de/sqliteodbc It fixes some Unicode length issues with the SQLite 2.8.17 version of the driver and now fully supports binary data. The Win32 version is now made with a MinGW cross compiler and NSIS. Enjoy,

Re: AW: [sqlite] [ANN] SQLite ODBC driver version 0.67

[EMAIL PROTECTED] wrote: > > Hi, > > I just would like to point out that: > > - a zip-archive for the drivers ("no-install") is not provided That was my intention; is the ZIP version really necessary ? > - the documentation for sqliteodbc.c / sqliteodbc.h is missing Ditto, since SQLite

Re: [sqlite] PRAGMA table_info

"Jackson, Douglas H" wrote: > > This leaves you to parse the DDL from sqlite_master. > Doug ... or to correlate 'pragma table_info(tablename)' with 'pragma index_info(tablename)'. Some (unreadable, imperfect) example code can be found in the ODBC driver e.g. in the functions SQLPrimaryKeys(),

Re: [sqlite] Compiling Sqlite JDBC driver (Compiler question)

[EMAIL PROTECTED] wrote: > > After I've been able to overcome the initial compiler problem (missing > library installation), I'm faced with a new one: > > 1) Compiling JDBC wrapper for 3.2.1 works fine > > 2) Compiling JDBC wrapper for 3.3.5 fails: > > cl -Gs -EHsc -D_WIN32 -nologo -Zi

Re: [sqlite] Compiling Sqlite JDBC driver (Compiler question)

[EMAIL PROTECTED] wrote: > > Christian, > > I understand Windows is poor, but I do not fully understand the > compilation process. The mkopc3.exe is actually created- so this itself > cannot be the problem. Not having awk doesn't seem to be an issue for > compiling the 3.2.1-based driver either

Re: [sqlite] Script perl e python, I can't open database from sqlite

"D. Richard Hipp" wrote: > ... > All core features have been thoroughly tested. I'm looking for problems > with the API. Do we need new parameters on some functions? Do we need > to change the semantics of some functions? Do we need to change the > semantics of some of the SQL. > ... Please

Re: [sqlite] Java

[EMAIL PROTECTED] wrote: > > Hi, > I'm new to SQLite and maybe was this already said, but is there a way to use > SQLite inside a Java program? > I've found Javasqlite (www.ch-werner.de/javasqlite) which is a JDBC Driver > for SQLite but it seems to work with versions SQLite 2.8.13 and this one

Re: [sqlite] I need a SQLite3 Wrapper for Java.

"[EMAIL PROTECTED]" wrote: > > Hello, > > and yes I do. I've tried to port, but without success. Please try out http://www.ch-werner.de/javasqlite/javasqlite-20040919.tar.gz Right now (since 3.0.7 is out, big thank you to DRH!) it somewhat began to work on Linux. As usual it is very preliminary

[sqlite] ANN: SQLite ODBC Driver 0.65

Hi all, a new version of the SQLite ODBC Driver is available on http://www.ch-werner.de/sqliteodbc An unoptimized driver version supporting SQLite 3.0.7 is included. Best regards, Christian

Re: [sqlite] sqlite with Java

On 03/19/2017 05:38 PM, Sylvain Pointeau wrote: On Sun, Mar 19, 2017 at 4:57 PM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: Why don't you provide an up-to-date version? this lib seems dead when we look at the website, also why don't you put the sources on git it would be easier to

Re: [sqlite] sqlite with Java

On 03/19/2017 06:38 PM, Sylvain Pointeau wrote: IMO it is no good idea to discuss specific issues of an only indirectly SQLite related library on this mailing list OK yes I agree, where can we discuss about it? C'mon, you apparently obtained the source code of this dead project, didn't

Re: [sqlite] sqlite with Java

On 03/18/2017 02:01 PM, Sylvain Pointeau wrote: If properly installed there should be no need to explicitly set a path. You mean in the JDK (or JRE)? (if yes -> this is not always possible) another question, do you confirm that sqlite3 is included into sqlite_jni.dll? Now I'm a little bit

Re: [sqlite] sqlite with Java

Could it be updated to the latest version of sqlite, seems it is pretty outdated now. Totally outdated but still compiling even with most recent SQLite 3 (and 2) versions and having autoconf OOTB support for SEE. Must be steampunk then ;-) Could it be also improved? not needing to set the

Re: [sqlite] sqlite with Java

On 03/18/2017 06:21 AM, Sylvain Pointeau wrote: I don't really want to use odbc in Java. I was thinking of https://github.com/xerial/sqlite-jdbc but how to use SSE in this case? seems the build is not so easy. You could use http://www.ch-werner.de/javasqlite which can be built with SEE. Best,

Re: [sqlite] Is it possible to create the Stored Procedure (SP) in Sqlite?

On 04/15/2017 06:18 PM, Richard Hipp wrote: On 4/15/17, Manoj Sengottuvel wrote: Hi Richard, Is it possible to create the Stored Procedure (SP) in Sqlite? if not , is there any alternate way for SP? Short answer: No. Longer answer: With SQLite, your application is