Project Description
Mini SQL Query is a minimalist SQL query tool for multiple databases (MSSQL, MSSQL CE, SQLite, OLEDB, MS Access/Excel files etc).

Make sure you read the Quickstart for an introduction

The Latest - Bug fix on connection refresh issue...
PK :-)

Mini SQL Query Screenshot

Mini SQL Query is "deliberately minimalist". Software too often becomes bloated and less usable while trying to satisfy the 99% of what every user wants. Mini SQL Query aims to satisfy the most common tasks what the average user seeks to achieve, in doing so it keeps the size and complexity of the application to a minimum.

Some Core features:
  • Supports multiple databases (MSSQL, MS Access, SQLite, Oracle, OLEDB, SharePoint etc)
  • Integrated text templating system for generating SQL, code or data scripts
  • Syntax highlighting (with printing support)
  • Load and save SQL script files
  • Generic batch support (using the 'GO' keyword but for any DB including SQLite, MSAccess etc)
  • Quick View table data
  • Basic query generation
  • Extensible programming model

Note that the target audience for this tool is not developers who tend to only deal with MSSQL, it's geared towards having to hit several different database sources...

Like to get involved? See Setting-up-a-Mini-SQL-Query-Development-Environment.

Originally hosted out of my site - http://www.pksoftware.net/MiniSqlQuery/ - also see the blog for some info but needs updating!

 pk software dev blog - Mini SQL Query News Feed 
Tuesday, July 03, 2012  |  From pk software dev blog - Mini SQL Query

I had an email the other day from someone having trouble with the connection editor in Mini SQL Query. It turns out that the way I had the refresh of the connection list setup, whatever the currently selected connection was before choosing a new one caused a bit of a loop if that connection failed. You can get around it by closing the editor and re-opening it etc but that is not real user friendly (hot tip!)


That bug has been there for years and I am pretty sure he was not the only one who experienced it! Thing is with software, if you have an issue you can be sure that it's happening for many more than just that one person.


If you are an open source software consumer, make sure you notify the authors of issues as their development environment may not reflect what you see. Don't expect every comment to get fixed, in fact I never even expect a reply simply because I know how busy things can get.


Anyway, there is a new release up on CodePlex: http://minisqlquery.codeplex.com/releases/view/90478


PK :-)

Tuesday, July 03, 2012  |  From pk software dev blog - Mini SQL Query

I had an email the other day from someone having trouble with the connection editor in Mini SQL Query. It turns out that the way I had the refresh of the connection list setup, whatever the currently selected connection was before choosing a new one caused a bit of a loop if that connection failed. You can get around it by closing the editor and re-opening it etc but that is not real user friendly (hot tip!)


That bug has been there for years and I am pretty sure he was not the only one who experienced it! Thing is with software, if you have an issue you can be sure that it's happening for many more than just that one person.


If you are an open source software consumer, make sure you notify the authors of issues as their development environment may not reflect what you see. Don't expect every comment to get fixed, in fact I never even expect a reply simply because I know how busy things can get.


Anyway, there is a new release up on CodePlex: http://minisqlquery.codeplex.com/releases/view/90478


PK :-)

Monday, September 06, 2010  |  From pk software dev blog - Mini SQL Query

I have finally had a chance to put together a simple "Quick Start" document for Mini SQL Query. It's the main reason I have never made a formal "version 1" release!


Here is a link to the document: Mini SQL Query Quick Start [http://pksoftware.net/Content/MiniSqlQuery/Help/MiniSqlQueryQuickStart.docx]


I also "upgraded" the projects to version 3.5 of the framework as the version 2 requirement is all but gone. That was more around my usage on Windows Server 2003 etc.


 


PK :-D

 pk software dev blog - Mini SQL Query News Feed 

Last edited Jan 28, 2013 at 11:12 PM by paulkohler, version 30