Ask Your Question

Base connecting to SQLite db on a Macbook

asked 2018-05-29 21:27:06 +0100

Kopfschlaeger gravatar image

I want to bring an sqlite database into Base. Java development kit is downloaded. I downloaded, but cannot open it. (1) where do I get the right version for Mac and (2) what do I do with the file once I have it (e.g. where does it go)?

edit retag flag offensive close merge delete




Know very little about Mac but here is a bit of info. On Linux have never gotten connection to SQLite using JDBC (Java connector). Only way was to use ODBC. Not sure where to get this for Mac as all I can find (without cost) is for Linux & Windows. Also, here is my post on setting up -> Base: how to connect to an SQLite database?

Ratslinger gravatar imageRatslinger ( 2018-05-29 23:28:16 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-05-29 23:58:45 +0100

Ratslinger gravatar image

updated 2018-05-30 01:03:36 +0100


Did a little more searching. First make sure you install Oracle JDK (Java) first. Base will not work at all without this.

Here is a post which describes how to use SQLite in OS X -> Use LibreOffice Base as a GUI for an SQLite database in OS X. Link for driver is there also.


It may not be necessary to install JDK when using ODBC connector. However some functionality is lost (Report Builder, Wizards and possibly a bit more).

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more



It might be worse than it appears. See this bug report (mine!) and the comment trail under it. At the moment would-be Base users might be scuppered on OSX, but I might be missing something.

David gravatar imageDavid ( 2018-05-30 00:53:26 +0100 )edit

@David Please see edit in answer.

Ratslinger gravatar imageRatslinger ( 2018-05-30 01:04:04 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-29 21:27:06 +0100

Seen: 296 times

Last updated: May 30 '18