• Welcome, Guest. Please login.
 
July 14, 2020, 06:13:15 am

News:

Welcome to the SQLitening support forums!


Need an interactive DBMS

Started by John Montenigro, August 03, 2009, 02:17:21 pm

Previous topic - Next topic

John Montenigro

OK, dumb question: I'm gathering that SQLitening is an "access method" and that it does not actually provide the DBMS itself. (yes/no?)

Aside from MS Access, is there a readily available (and free?) interactive DBMS that I can use to do some quick and dirty data analysis?  I 'm looking forward to using PB and SQLitening later to build a front end, but for now I need an interactive DBMS...

Thanks,
-John


Background info:

I have three .TXT files representing three tables of normalized data -
File/Table 1: ID#,Names,Address
File/Table 2: ID#,Counties
File/Table 3: ID#,Skillsets

Counties and Skillsets can be many to one Name. In other words, a person can work with multiple and different skillsets in multiple and different counties...  There is much more data of course, this is oversimplified...

I need to be able to submit queries like this:
SELECT Name, County, Skill, from T1, T2, T3
WHERE  Names.ID# = 1001 AND Counties.ID# = Names.ID# and Skillsets.ID# = Names.ID#

I expect to get back stuff like this:
1001,Name021,County003,Skill001
1001,Name021,County003,Skill007
1001,Name021,County003,Skill052
1001,Name021,County032,Skill007
1001,Name021,County032,Skill045
1001,Name021,County075,Skill045








Rolf Brandt

SQLitening is an extension for the SQLite Database System. It provides Client/Server access for SQLite databases. It is easy to use with PowerBasic, and it is "Litening" fast.

If you want to work with SQLite databases without buildung your own frontend there are a couple of good programs on the market - also freeware. I would recommend

SQLite Expert
They have a free and a commercial version ($ 59,00). The free version really should do everything you need.
http://www.sqliteexpert.com/


SQLiteAdmin
Also worth looking at is SQLiteAdmin. It's freeware.
http://sqliteadmin.orbmu2k.de/

Rolf
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Fred Meier

MS Access is not a "Interactive DBMS" rather it is a shell/front-end to
the Jet DBMS (Joint Engine Technology) just like the two Rolf refers to
are shell/front-ends to SQLite. 

SQLitening is a programming shell/front-end to SQLite DBMS just like MS
DAO is to the Jet DBMS.  SQLitening supports Client/Server while MS DAO does not. 

MS Access is excellent for analysis and quick throw-aways, I still use it
for that.  Beware that MS has not updated Jet in sometime and has implied
that it is "dead" and SQL Server Express is its replacement. 
http://www.databasedev.co.uk/jet-database-engine.html

John Montenigro

Thanks Rolf and Fred, that's good info and I'll be following up with it over the next week or so.

Meanwhile, I tried using Access, but it did not seem able to process the SELECT I posted in my message above. I find the MS Access helpfiles incomprehensible. They've been absolutely no help to me.

I used to write SQL queries against mainframe DB2, so that's how I think, and I realize that my SQL statements may not be syntactically compatible with MS Access... but I don't know in what ways.

Thanks for any info you can point me to.
-John

Fred Meier

Attached is a Jet SQL help file.

John Montenigro

Fred,

I found where some of my syntax was in error, and now I'm getting results... Thanks for your help.

I'll try sqliteexpert next week sometime.

-John


Bern Ertl

Quote from: John Montenigro on August 03, 2009, 05:04:03 pmI used to write SQL queries against mainframe DB2, so that's how I think, and I realize that my SQL statements may not be syntactically compatible with MS Access... but I don't know in what ways.


You can find a pretty clear description of the SQL language that SQLite understands here:

http://www.sqlite.org/lang.html