LOBase connected to SQLite3

users
#1

Good afternoon,
May I ask for some help and advice.

My prime intention is to start building database applications using SQLite3. I first tried to install Apache & PHP&SQLite3 as separate programs but the config process was too much for me why I installed WAMP2.4.As you know is WAMP a package of Apache, PHP and MySQL(v.5.6.) and the SQLite3 is an extension in PHP(v. 5.5.).

When I have been using LibreO for many years now why it should be nice if I could use LOBase as a front end with SQLite as the db-engine.

My question is: is it possible to connect LOBase to SQLite3?
And if so, how shall it be done -- where can I find a guide?
Is the process similar as when connecting to MySQL?

My system is Windows7prof64bit; LO4.3.4.

Thanks in advance

Pertti Rönnberg (Finland)

#2

Hi :slight_smile:
There is some documentation about Base at;
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook

Plus the Faq pages are complete for Base, even ahead of some of the other
modules/programs/apps;
https://wiki.documentfoundation.org/Faq/Base

I'm not sure if anything there is specific to SQLite but it might help you
figure out specific questions.
Regards from
Tom :slight_smile:

#3

Pertti ,

I supose there can always been connected on Windows using ODBC or ADO when no native connector is available.
You can test this to connect a Base document to your SQLite server

Greetz

Fernand

#4

Hi,

My question is: is it possible to connect LOBase to SQLite3?

Yes, it is. You'll have to use an ODBC driver that you can get here:
http://www.ch-werner.de/sqliteodbc/

And if so, how shall it be done -- where can I find a guide?
Is the process similar as when connecting to MySQL?

It is *much* easier :wink:
Don't forget to download the SQLite Browser tool as well as it is very
good at working on your SQLite databases. See:
https://github.com/sqlitebrowser/sqlitebrowser/releases/download/v3.4.0/sqlitebrowser-3.4.0-win32.exe

You'll have to configure the ODBC driver to point to the directory where
your database resides.

Now, start LibreOffice Base and select ODBC

HTH,

#5

As a starting point, take a look at:
http://www.openoffice.org/documentation/HOW_TO/data_source/SQLite.pdf

And a project that looks defunct:
http://www.openoffice.org/dba/drivers/sqlite/index.html

jonathon

#6

Hi Pertti,

My prime intention is to start building database applications using
SQLite3. I first tried to install Apache & PHP&SQLite3 as separate
programs but the config process was too much for me why I installed
WAMP2.4.As you know is WAMP a package of Apache, PHP and MySQL(v.5.6.)
and the SQLite3 is an extension in PHP(v. 5.5.).

You can try to connect to your SQLite datasource either via ODBC or
JDBC. Using Google to search for drivers brings up a few.

An example here of someone on Ubuntu :
http://en.libreofficeforum.org/node/2038

Note that there are a few known bugs with current versions of LO and
SQLite3, the last one being a limitation of sqlite3 (notourbug) :

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=82688

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=86943

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=50575

Alex

#7

Hi all of you,
Thank you for your time and your answers.

Now I'll have something to do while waiting for Santa Clause and all the presents.
Creating dbs and learning new (HTML, PHP, SQL) is good execise for a 75 years old brain.

Merry Christmas and
a Happier New Year 2015
Pertti