Topic: Sqlite demo

I'm new to simplyfortran and was searching for a demo using sqlite and found nothing.

Does anyone know of a sqlite demo showing the basics of  opening/creating  a database, creating tables/views/triggers, and inserting/updating tables?

Re: Sqlite demo

SQLite is a C library, so calling these routines from Fortran is not completely straightforward.  You have a few options:

1. Create interfaces for the SQLite routines you need

2. Use an existing wrapper for Fortran

We do offer a packaged version of the FLibs SQLite interface for Windows, and it wouldn't be too hard to build for Linux or macOS.  Are you trying to do this on Windows?

Jeff Armstrong
Approximatrix, LLC

Re: Sqlite demo

I'm on Windows 10. I've downloaded the flibs zip and unzipped it, but I see no instructions on where to install the unzizpped files.

Re: Sqlite demo

The zip file probably contains all the Flibs source code, which you'll need to compile yourself.  You'd also need to download and compile SQLite as well.  On Windows it can be a tedious task, which is why we offer a pre-built distribution through our package manager.

Jeff Armstrong
Approximatrix, LLC