I was looking at the SQL on the lexicon, but couldn’t find working examples. Is there a place to see basic examples such as Where/When/How do we create the db, tables and columns, Incrementing Column Data, Append ect?
Can this be a replacement to NWNX:EE?
Some examples at https://github.com/Finaldeath/nwscript_utility_scripts/tree/master/sql (sqllocals has table creation, variable binding, etc).
DB from nwnx is pretty replaceable. If you don’t need outside access (i.e. webpage) or stored procedures more complex than sqlite allows, game alone should be fine. If need to transfer existing data to an sqlite db the game can use that’s possible too.
That looks helpful. Thank you kindly!