Database Table Creation

[lrose]

@jason_kensett

I first thought that was “big”, but now I think big in this contexts means more like millions and billions.

We have all been there.

Ignition is great at connecting to and getting information from DB's of many different flavors. It's one of the many attractions of the platform, but it is by no means a Database management system.

You should absolutely get in the habit of setting up tables with proper indexing. Start now and you'll thank yourself for it later. Inevitably, your "few thousand items" will quickly turn into several thousand rows of data.

There are several posts around the forum that deal with DB architecture. Here is one such:

Help with SQL Query to write data from one DB table to another for a monthly report

Real quick crash course: A primary key is key that uniquely identifies a record in a database table. Sort of like a mathematical function (in the strictest definition of a function) where every input maps to exactly one output, and no two inputs will give you the same output. In the most basic form, one that’s widely used, this would be an id column in a table. So this means if you want record 5, you do SELECT * FROM table WHERE id = 5, and that is the ONLY way you can see record 5 (when onl…