Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

> Now I'm a little bit confused. You asked for an SEE enabled SQLite Java
> binding. This requires you to 1. obtain your SEE license from DRH's company
> and 2. to use the SEE sources and compile/link them to
> {lib,}sqlite_jni.{dll,so}
> for your target platform.
>

Don't be confused, I know all that, but before to buy the SSE (it is
2'000), I need:
1- to choose a sqlite jdbc driver allowing SSE (done)
2- to test the java driver to see if I can migrate successfully from H2 to
sqlite (I will do that in the next coming week(s))
3- to really assess if I need still need encryption in my project (after
some recent changes)

For now I tested your driver (quicky) and it seems I can use it, so 1 is
done, I need to do 2.


>
> So in any case involving SEE you have to rebuild things from source code
> and deal with deployment on the target environment.
>
>
Yes and I have a compiler on another machine, but for a matter of testing
quickly, I would not like go through the compile cycle.
Anyway, for now I tested with the outdated version (3.7.7.1)

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 contribute or raise a bug if any...
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Christian Werner]

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 confused. You asked for an SEE enabled SQLite Java
binding. This requires you to 1. obtain your SEE license from DRH's company
and 2. to use the SEE sources and compile/link them to {lib,}sqlite_jni.{dll,so}
for your target platform.

So in any case involving SEE you have to rebuild things from source code
and deal with deployment on the target environment.

Regarding the {lib,}sqlite_jni.{dll,so}: it depends on the platform,
for Windows the SQLite 3 (and optionally 2) engine usually is directly linked
into that library. For Linuxen many distros have a javasqlite-something
package where the maintainers chose to dynamically link to the system
SQLite 3 library.

HTH,
Christian

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

On Sat, Mar 18, 2017 at 1:04 PM, Christian Werner <
christian.wer...@t-online.de> wrote:

> 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
> ;-)
>

I am on a computer without compilers, it would have been good if I could
test with the latest version.

Could it be also improved? not needing to set the path of the native
>> library? like xerial made it, is it possible?
>>
>
> 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?

Best regards,
Sylvain
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Christian Werner]

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 of the native
library? like xerial made it, is it possible?


If properly installed there should be no need to explicitly set a path.


does this jdbc driver give the metadata?


Yes.

Best,
Christian

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

Le sam. 18 mars 2017 à 09:53, Christian Werner 
a écrit :

> 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.


OK I can give it a try.

Could it be updated to the latest version of sqlite, seems it is pretty
outdated now.
Could it be also improved? not needing to set the path of the native
library? like xerial made it, is it possible?

does this jdbc driver give the metadata?

Best regards,
Sylvain


>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Get version at runtime

[Cecil Westerhof]

2017-03-18 10:13 GMT+01:00 Keith Medcalf :

>
> SQLite version 3.18.0 2017-03-17 23:08:11
> Enter ".help" for usage hints.
> Connected to a transient in-memory database.
> Use ".open FILENAME" to reopen on a persistent database.
> sqlite> select sqlite_version();
> 3.18.0
> sqlite> select sqlite_source_id();
> 2017-03-17 23:08:11 f4cf8635e6fec6f04075cc067aaa71
> abc4f71739068e0ad2c44609dcb8691009
> sqlite>
>

​I need: SELECT sqlite_version() AS 'SQLite Version'.
Thanks.
​



> > -Original Message-
> > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> > On Behalf Of Cecil Westerhof
> > Sent: Saturday, 18 March, 2017 03:09
> > To: SQLite mailing list
> > Subject: [sqlite] Get version at runtime
> >
> > If I recollect correctly there is a way to determine at runtime what the
> > version of SQLite is. But I do not remember how. How can this be done?
>

-- 
Cecil Westerhof
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Get version at runtime

[Keith Medcalf]

SQLite version 3.18.0 2017-03-17 23:08:11
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> select sqlite_version();
3.18.0
sqlite> select sqlite_source_id();
2017-03-17 23:08:11 
f4cf8635e6fec6f04075cc067aaa71abc4f71739068e0ad2c44609dcb8691009
sqlite>

> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of Cecil Westerhof
> Sent: Saturday, 18 March, 2017 03:09
> To: SQLite mailing list
> Subject: [sqlite] Get version at runtime
> 
> If I recollect correctly there is a way to determine at runtime what the
> version of SQLite is. But I do not remember how. How can this be done?
> 
> --
> Cecil Westerhof
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Get version at runtime

[Cecil Westerhof]

If I recollect correctly there is a way to determine at runtime what the
version of SQLite is. But I do not remember how. How can this be done?

-- 
Cecil Westerhof
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Christian Werner]

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,
Christian

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users