PDA

View Full Version : SQL Tutorial



Jim
2005-11-26, 05:50
Anyone know of a reasonable freeware GUI-Based Windoze (possibly Linux too) SQL client? I personally use the excellant Navicat (http://www.navicat.com) client but that costs money. I know Access could be used with ODBC but that's crap, and again costs money.

I was thinking of putting together a few SQL tutorials so people could look at their SlimServer data, spot problems, find out things etc...

Obvious things could be reports of missing tags, dodgy looking files, a list of files recognised compared to a dir list for example.

max.spicer
2005-11-26, 06:33
Assuming you're talking about SQLLite, http://sqllitebrowser.sf.net. For ODBC or JDBC, winsql is very good: http://www.indus-soft.com/SynametricsWebApp/WinSQL.jsp. It has a free version, but also has non-free versions with more features.

Max


Anyone know of a reasonable freeware GUI-Based Windoze (possibly Linux too) SQL client? I personally use the excellant Navicat (http://www.navicat.com) client but that costs money. I know Access could be used with ODBC but that's crap, and again costs money.

Jim
2005-11-26, 06:45
Thanks Max, wasn't thinking strictly SQLlite (mySQL too). I suppose someone installing mySQL probably doesn't need a SQL tutorial, or is able to use the included command line stuff.

I thought WinSQL but it is severely crippled in the freeware version as to prove useless (no data browsing for example).

I'll write up some useful statements and worry about that afterwards.

P.S. Only 1 L... http://sourceforge.net/projects/sqlitebrowser/

max.spicer
2005-11-26, 14:39
I wouldn't say it was useless, although the lack of browse is a minor inconvenience. If you can still download the older versions, they do have browsing enabled in the freeware version - it was only recently removed. If my memory of version numbers isn't too far out, I think you want a pre 4.5 release (4.1?).

Max


I thought WinSQL but it is severely crippled in the freeware version as to prove useless (no data browsing for example).

cherise
2005-11-28, 01:43
You could try the database app that comes with the icreasingly good (and free) Open Office suite (http://www.openoffice.org) - sort of Access lookalike, works well for me.

max.spicer
2005-11-28, 06:59
Thanks for that recommendation! I've just been playing with this at work and am immediately a fan. It's easily better than our current favourite, WinSQL, and is cheaper too. I suspect we'll be buying a few copies in the not too distant future!

For non-commercial use, this product is free so I'd definitely recommend giving it a look.

Max

Patrick Dowling wrote (in the dupe of this thread):
I use and have been quite happy with Aqua Data Studio http://
aquadatastudio.com/index.html which has two versions one that is free
for personal use and an older one which is free for all use
commercial or personal.

Pat