Mirror of forum.nim-lang.org

9598 :: How can I get the fields and field-types of an sqlite-database?

• Hobbyman (orginal) [2022-11-11T10:58:31+01:00] view original

  I am beginning to work with sqlite and would like to read somehow the fields and field-types of a table. Can this be done? And if yes then how? Or maybe not with the standard-lib db_sqlite? With another one?

  The reason is that I want to create a generalized database-form (in html) which I only give the table-name, and which extracts the necessary meta-info from the database.

  If it is not possible I could create a table in which I put this meta-info, but that would be extra work.

  Thanx in advance, Joris.

---

• sky_khan (orginal) [2022-11-11T11:19:20+01:00] view original

  Sqlite is kinda schemaless, columns does not really have types. They have only declared types. You can store anything in any column. Still, you may query "sqlite_master" table but you'll have to parse DDL clause yourself

---

• Clonk (orginal) [2022-11-11T11:34:51+01:00] view original

  Your best option is to use https://github.com/moigagoo/norm

---

• mikra (orginal) [2022-11-11T16:14:56+01:00] view original

  https://www.sqlite.org/datatype3.html

---

• Hobbyman (orginal) [2022-11-11T20:32:58+01:00] view original

  All usefull information. Thanx! For now I go for the sqlite_master table, but the Norm-option looks quite interesting and worth investigating...and with copious documentation..

---