HOW TO CREATE A SQLITE DATABASE INSTALL
HOW TO CREATE A SQLITE DATABASE DRIVER
HOW TO CREATE A SQLITE DATABASE SOFTWARE
HOW TO CREATE A SQLITE DATABASE PASSWORD
HOW TO CREATE A SQLITE DATABASE WINDOWS

Say you have an application where users can enter values in, and you needed to store those temporarily. Things like user preferences or configurations made during runtime. Instead this option is ideal if you want it to store non-production data. In those cases, you're going to want to use a stand-alone Client-Server Style SQL Database. Lots of simultaneous queries, such as those generated by our historian systems, our alarm journals and our audit profiles end up straining the SQLite Connection quite a bit. However, in a production environment, we don't recommend you use this as a historian database. If you're just getting started with ignition or you're working on a demonstration or proof of concept, then it's a fine database to use. It's more designed for smaller scale interactions and applications. SQLite isn't really designed to compete with Client Server Style Databases. Now let's end with a caveat here, talking about the SQLite connection options. You wouldn't store a longterm records inside of this. So you'd really only want to use this in-memory option for temporary things. Once you shut down your gateway or restart your gateway, all of the entries inside of that database will be gone. Now as you've probably guessed by creating a database that sits only in-memory. The database just lives in the gateway's memory. And now we have yet another valid database connection. And of course we'll take care of that example in future versions. We need a colon at the end, which I'll just add here.

HOW TO CREATE A SQLITE DATABASE SOFTWARE

Now in this version of the software I'm using there's a slight typo in the example. And I'm going to replace what I have up here, with what I just copied. So we can simply select this example here. So how about in-memory? So one of the things you can do because SQLite is such a lightweight database, is that instead of creating the database as a file that sits on the file system, the gateway can actually create the database and keep it in-memory. So first of all, let's give this a name here. And you may have noticed under these examples here, there's this memory example. I'm going to create another database connection and just like last time I'll select a SQLite. We can also use this alongside other Ignition features such as named queries or the alarm journal. It works just like any other SQLite Database Connection, in that you can create tables in here, and start writing queries. So now we can use the SQLite Database Connection to start storing things. If we head back to our directory, we can see that the database was created. And we can see it's valid and it's up and running. Let's scroll down and create the connection. Be mindful of storing sensitive information here in these connections.

HOW TO CREATE A SQLITE DATABASE PASSWORD

Looking at the username and password here, we don't use any authentication for SQLite, so I'll leave those blank. So I'm going to add a backslash and then type in the name of the file I want to create. Now we do need to point this URL to a file. As long as the folders along the path exist.

HOW TO CREATE A SQLITE DATABASE DRIVER

So backslashes are used in between folders and files, but the driver would work here with forward slashes as well.

HOW TO CREATE A SQLITE DATABASE WINDOWS

I'm using a Windows Operating System, obviously. Just got a backspace so that you can see what I did, and I'm going to paste that path I just copied. I'll head back to the connect URL and I'm going to replace everything after the 'JDBC:SQLite' part here. Now I'm going to select this path and copy. It's empty right now, but I'm going to have the SQLite Database Connection, create the database inside of this folder. Now off-screen here, I have a folder I created inside of my Ignition Installation Directory. Unlike other connection types, we simply need to provide a file path to either an existing SQLite Database file or provide a path to a nonexistent file, which will cause this connection to create the database for us. And let's give this connection a name here, much like other database connection types and ignition. And from my list of options here, I'm going to select the SQLite option.

So I'll click on the create new database connection link. And instead, I'm going to create a SQLite Database. I do have a MySQL database connection, but we're going to ignore that. I am under the config section here, under databases and connections. Speaking of getting started, I'm looking at my Gateway. Once you have Ignition installed, you can create a connection and get started.

HOW TO CREATE A SQLITE DATABASE INSTALL

What's nice about SQLite is that you don't need to install any separate software to use it with your Gateway. This differs from Client-Server Database Management Systems like Postgres and MariaDB, which are standalone programs. It's designed to be embedded into other programs. SQLite is a lightweight self-contained SQL Database.

In this lesson we'll take a look at creating SQLite database connections.

How to create a sqlite database