Store and SQLite3

I’m not a fan of PostgreSQL on the Mac. The easiest way to get it working on the Mac is, in my opinion, with PostgreSQL for Mac but I’ve found that 4 out of 5 of the packages they distribute have problems. Besides that, I don’t like the idea of running a database server on my machine just for source code management. So I decided to take a look at Store for SQLite specifically the SQLite3 iteration.

The first problem I encountered was documentation on setting up the Store connection. I finally figured it out by a posting in a forum but I though I’d list out the steps here.

First install the StoreForSQLite3 package from the Cincom Public Repository. If you don’t know how to do this check out the Source Code Management Guide that comes with VisualWorks, under the heading Install Store into VisualWorks. Just in case your curious about what version, I installed version sqlite3-vw7.x 8,mlucassmith and when prompted to load a SQLite3EXDI version I installed sqlite3-vw7.x 9,mkobetic.

Next set up the database tables. This is explained in the Source Code Management Guide under the heading Install the Store database tables. When prompted for a connection set the fields as follows:

  • Interface: select SQLite3Connection
  • Environment: Enter the file name where you want SQLite to store the database. If you just enter a file name, like store.sq3, the file will be stored where the current image is stored. You can enter a fully qualified name, like /Users/Sean/store.sq3 for Mac. I’m assuming the same thing works on Windows and Linux but I haven’t tried it.
  • User Name: I don’t think this is used by SQLite but Store needs it so put your name in
  • Password: can be left blank
  • Table Owner: I left the default of BERN

You’ll probably want to save the connection for later use so hit the Save… button and give it a useful name.

Follow the rest of the instructions for installing the database tables from the Source Code Management Guide.

You should see the tables being built in the Transcript. It goes quick so it may seem like nothing happened but the Transcript will show a successful install if it all worked.

If you go to the folder that you specified for the file (or the folder where the image is) you should see the file. Now you’re in business and can use Store with SQLite.

I messed around with it for a little while and it seems to work fine but I haven’t put it through any serious tests. Has anyone else?


1 comment so far

  1. Kim Sullivan on

    On windows, don’t forget to download the sqlite3.dll file and put it somewhere VisualWorks can find it (for example, the bin directory). I lost several hours trying to find out why I got an exception 😉

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: