[AccessD] SQLLite

[Stuart McLachlan]

I'd stay away from SQL Server Compact for any new developmnt.

According to Wikiipedia:
The latest, and last, release is the SQL Server Compact 4.0.[1] As of February 2013 SQL 
Server Compact Edition had been deprecated; no new versions or updates are planned, 
although Microsoft will continue to support until July 2021.

According to the official:  MS Download site Last Release 2012. Highest supporteed 
Windows version is Win 7.

https://www.microsoft.com/en-US/download/details.aspx?id=17876




On 8 Jan 2019 at 17:13, Daniel Waters wrote:

> 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com