[AccessD] SQLLite

[Daniel Waters]

Hi John,

You should take a look at this page for a comparison of 5 different tools.  http://erikej.blogspot.com/2011/01/comparison-of-sql-server-compact-4-and.html

Also - ErikJ has a free Toolbox that I use to manage SQL Compact 3.5, and it also works with SQLite.  http://erikej.blogspot.com/

I use SQL Compact 3.5 because it supports Linq to SQL which I use throughout my application for queries against SQL Server.  SQL Compact is also integrated into my application in VS - I don't know if SQLite does that or not or if it makes much difference.

Good Luck with your Morrowind Add-On!
Dan 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: January 8, 2019 8:15
To: Access Developers discussion and problem solving; Stuart McLachlan
Subject: Re: [AccessD] SQLLite

>>>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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com