# SQlite and inductive studies **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [October 25, 2025, 9:10am UTC](https://forum.inductiveautomation.com/t/sqlite-and-inductive-studies/111716 "2025-10-25T09:10:32Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![coetzeetino](https://avatars.discourse-cdn.com/v4/letter/c/8491ac/32.png) [@coetzeetino](https://forum.inductiveautomation.com/u/coetzeetino)\ **Post date:** [October 25, 2025, 9:10am UTC](https://forum.inductiveautomation.com/t/sqlite-and-inductive-studies/111716/1 "2025-10-25T09:10:32Z")
I’m new to ignition and following the inductive university.Created the database with SQlite and followed the course “Building in perspective”I am at the part where i have to create a power chart but upon trying to connect the the database there is nothing showing up under the tag panel. I spent the better part of 5 hours trying to Google the issue with no resolve ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [October 25, 2025, 10:15am UTC](https://forum.inductiveautomation.com/t/sqlite-and-inductive-studies/111716/2 "2025-10-25T10:15:23Z")
> **[Datatypes In SQLite](https://www.sqlite.org/datatype3.html)** This doc states: > ## 2.2. Date and Time Datatype > > SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in [Date And Time Functions](https://www.sqlite.org/lang_datefunc.html) of SQLite are capable of storing dates and times as TEXT, REAL, or INTEGER values: > > - **TEXT** as ISO8601 strings ("YYYY-MM-DD HH:MM:SS.SSS"). > - **REAL** as Julian day numbers, the number of days since noon in Greenwich on November 24, 4714 B.C. according to the proleptic Gregorian calendar. > - **INTEGER** as Unix Time, the number of seconds since 1970-01-01 00:00:00 UTC. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/e/3e5db0e271cb436675800576ed79310e3de7706d.png) The historian tables require a DATETIME datatype column. You haven't got one. I think you'll need a grown-up's database! ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [October 25, 2025, 10:29am UTC](https://forum.inductiveautomation.com/t/sqlite-and-inductive-studies/111716/3 "2025-10-25T10:29:48Z")
The good news is: with docker, it’s super easy to spin up a database. If you’re not already using docker, I suggest you do that. Make a simple docker compose that will start an ignition container, and a db container (if you don’t have a requirement on the DB, pick Postgres), a volume for each of these containers, and a network so they can communicate. If you’re not familiar with docker this might sound complicated, but it’s really not. You can find docker compose examples easily, probably even on this forum, and any LLM can help you write one. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [October 26, 2025, 9:18pm UTC](https://forum.inductiveautomation.com/t/sqlite-and-inductive-studies/111716/4 "2025-10-26T21:18:16Z")
Sqlite _can_ be used as a history provider in ignition, it's just not recommended for anything other than testing. Although I was using it originally on my rpi at home storing flow meter readings. I've since replaced it with mariadb. That date time field in the history tables likely just use integers. To reply to the OP though, have you configured any tags to have history enabled? ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [October 26, 2025, 9:21pm UTC](https://forum.inductiveautomation.com/t/sqlite-and-inductive-studies/111716/5 "2025-10-26T21:21:16Z")
> [@nminchin](#): > > That date time field in the history tables likely just use integers The t\_stamp column is integer, but storing `datevalue` seems to require a DATETIME. I have no idea if it will work if not storing datevalues. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [October 26, 2025, 9:23pm UTC](https://forum.inductiveautomation.com/t/sqlite-and-inductive-studies/111716/6 "2025-10-26T21:23:36Z")
It's kind of strange storing datetimes as the values anyway though 🤷