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 the stored procedure.
I
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 you?
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 c
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 path
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&ln=1637-1682
i.e. calls android.conte
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...
The
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 u
ÕÅÊÀÎÅ 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 header
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
ht
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 databases
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
> load
"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 "resource
[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');
> I
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, thu
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: /sqli
[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, t
[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 s
Dorian33 wrote:
>
> I am looking for anybody who has managed to compile sqlite3 and build up any
> kind of application using arm-wince-mingw32ce tool.
It is possible nearly OOB when a custom makefile is used,
see http://www.ch-werner.de/pocketpc/Makefile.mingw32ce-cross
for a working example usin
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 PROTEC
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 bei
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 swi
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
http://www.sqlite.org/cv
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 erlier
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 experimen
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 off-li
Joe Wilson wrote:
>
> Hi Christian,
>
> Does your ODBC driver allow for SQLite loadable modules out of the box?
> If so, how do you specify the names of the module DLLs?
No, the extension loading is not supported yet, although compiled into
the Win32 driver DLLs. But it might be possible to crea
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.
Includin
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 Extensi
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 -DOS_WIN
"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(), SQL
[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 2.
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,
Chris
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
Jarl Friis wrote:
> Christian Werner <[EMAIL PROTECTED]> writes:
>
> > Jarl Friis wrote:
> >
> >> I have fixed a bug in the SQLite ODBC driver. The problem is that the
> >> ODBC driver does not use the info from "PRAGMA table_info(...)"
Version 0.66 of the SQLite ODBC Driver is available
on http://www.ch-werner.de/sqliteodbc
It supports now SQLite 3.3.4 and 2.8.17.
Cheers,
Christian
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 compile
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
Hi all,
I'm pleased to announce an alpha-version of an SQLite 2.8.x SDBC
driver for OpenOffice.org. So far only a Linux version is available.
For more information, see http://dba.openoffice.org/drivers/sqlite/index.html
Best regards,
Christian
[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 is
"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
54 matches
Mail list logo
