[AccessD] SQLLite

John Colby jwcolby at gmail.com
Tue Jan 8 08:14:42 CST 2019


>>>It's SQLite, not SQLLite :-)

Uhhhh yea!  lol

I have read all of those pages you sent me to.  They get quite deeply into the workings of the engine.  Hoping I don't have to understand all that stuff to start using it.  About to get the engine and studio and get to work.

It seems very "similar to" Access in the "one file holds everything".  The open source developers doing the game engine and the construction set (CS) engine do everything in C, and of course this is written in C.  I'm hoping I can crib parts of the CS already written which loads and unloads the game data to load that data into the SQLite database.

What are you using it for?

On 1/8/2019 5:57 AM, Stuart McLachlan wrote:
> It's SQLite, not SQLLite :-)
>
> Yes, I use it.  It's an extremely easy to use , powerful but lightweight engine which just uses
> one DLL.  And it's VERY widely used.
>
> Highly recommended.  Very fast storage and analysis witth aopropriate use of keys and
> indexes.
>
>
> Worth reading:
>
> https://www.sqlite.org/whentouse.html
>
> https://www.sqlite.org/about.html
>
> It would be well worth your time to download SQLite and SQLiteStudio and have a play.
>
> https://sqlitestudio.pl/index.rvt
>
>
>
>
> On 7 Jan 2019 at 23:28, John Colby wrote:
>
>> Is anyone in the group actively using SQLLite?  I am edging into a
>> role where I will need to select a database engine - for use
>> cataloging and analyzing objects in the game Morrowind, for use around
>> (but not inside of) OpenMW, a Morrowind engine rewrite. Note that I am
>> not on the open source coding team that is rewriting the Morrowind
>> game engine, I am proposing an addon to the efforts already well under
>> way.
>>
>> SQLLite seems appropriate given the small size of the data. SQLLite
>> seems to be used everywhere for smallish databases, and this seems to
>> be smallish data.
>>
>> Just looking for wisdom on SQLLite, ease of use (or lack thereof),
>> Power of the engine for storage and analysis of the data etc.
>>
>> -- 
>> John W. Colby
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
>
-- 
John W. Colby



More information about the AccessD mailing list