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
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
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
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
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
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,
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
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
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
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
** 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
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...
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
ÕÅÊÀÎÅ 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
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
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
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
>
"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
[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');
>
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,
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:
[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
[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
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
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
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
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
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
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
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
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
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
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:
-
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.
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'
>
> ?
>
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
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]
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
[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
[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
"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(),
[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
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,
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
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
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
"[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
[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
"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
49 matches
Mail list logo