Connector
SQLite Connector
Connect an SQLite database file to your other systems without writing code, on Windows or Linux.
Rapidi connects to SQLite 3.0 and later through RapidiConnector, installed on a machine that can reach the database file. That machine needs the SQLite3 client library, and Windows and Linux systems are both supported. You give the connection the path to the database file, and each SQLite database gets its own connection and RapidiConnector.
- What it connects to
- SQLite 3.0 or later database files, on Windows or Linux systems.
- What it reads
- The tables in the database file you name. Read Design loads them so you can map them.
- What you need
- RapidiConnector and the SQLite3 client library on a machine that can reach the database file.
What does this connector actually do?
The short version: SQLite needs no database server, so Rapidi works with the database file itself, through a RapidiConnector installed where that file can be reached.
| What it connects to | SQLite databases, the self-contained SQL engine that needs no server. Version 3.0 or later. |
|---|---|
| Where it can run | Windows and Linux systems, as long as the database file can be reached from where RapidiConnector is installed. |
| How it finds the database | A Database Path field on the connection holds the path and name of the SQLite database file. |
| More than one database | Each SQLite database gets its own connection in MyRapidi, and its own RapidiConnector. |
| What it needs on that machine | The SQLite3 client library. If it is not on the system path, its location goes in the rapidi.cfg file under SQLiteLibName. |
| How often it runs | On a schedule you set. The shortest interval depends on your plan, from one hour on Entry down to one minute on Unlimited. |
| What you set up once | Install RapidiConnector and the SQLite3 client library, enter the database path in MyRapidi, then press Test and Read Design. |
What goes on your side?
An SQLite database is a file, not a server, so the pieces Rapidi needs sit on a machine that can open that file.
| What you are comparing | RapidiConnector | SQLite3 client library |
|---|---|---|
| What it is | A small service you download from MyRapidi | The standard SQLite library, from sqlite.org on Windows or the package manager on Linux |
| Where it goes | A machine that can reach the database file. Windows, or some Linux versions after a check with us | The same machine as RapidiConnector |
| What it does | Opens a connection out to the Rapidi service, keeps it open, and carries the data between the database and the other system | Lets RapidiConnector open and read the SQLite database file |
| How it is set up | Install it, then enter the Rapidi Service ID, user ID and password shown in MyRapidi | Install it on the system path, or name its location in rapidi.cfg under SQLiteLibName |
| Ports opened to the internet | None. It calls out, so nothing is opened inward | None |
Running RapidiConnector on Linux is possible on some versions. Tell us which one you use and we will confirm it before you plan around it.
Where does SQLite show up in a Rapidi integration?
SQLite is usually the local database inside an application or device. These pages show how Rapidi uses a database connection like it.
Where do you go next?
Connectors
Every system Rapidi connects to
The full connector list, A to Z, with versions and how each one connects.
All connectors
Connector
Microsoft SQL Server
The other database connector that runs through RapidiConnector on your own network.
Database connector
Pricing
What Rapidi costs
Four plans, priced per subscription rather than per connector. Adding SQLite does not change the licence.
Plans
Your setup
Ask about your own database
Tell us which SQLite version you run and what it has to connect to, and we will say plainly how Rapidi covers it.
Talk to a consultant
Frequently asked questions
Can Rapidi connect to an SQLite database?
Yes. SQLite has its own connection type in MyRapidi. You give it the path to the database file, test the connection and read the design, and the transfers are configured on screen rather than in code.
Which SQLite versions are supported?
SQLite 3.0 or later.
Does it work on Linux as well as Windows?
The database can sit on Windows or Linux, as long as the file can be reached from the machine running RapidiConnector. RapidiConnector itself runs on Windows, and on some Linux versions, so tell us which Linux you use.
What has to be installed on our side?
RapidiConnector and the SQLite3 client library, on a machine that can reach the database file. RapidiConnector opens a connection out to the Rapidi service and keeps it open, so nothing on your network has to accept connections in.
We have several SQLite databases. How does that work?
Each database gets its own connection in MyRapidi, with its own RapidiConnector installed where that database file can be reached.
Which way can the data move?
Tell us which direction you need. The SQLite documentation does not spell out the direction, so we confirm it for your setup before you plan around it.
What does the SQLite connector cost?
Nothing on its own. Rapidi is priced per subscription plan rather than per connector, so adding SQLite does not change the licence.
Is your SQLite database ready to connect?
Tell us where the database file lives and what it has to talk to, and we will tell you plainly what the setup involves.