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 - Something went wrong with 1.0.71.456! This is fixed now in version 1.0.72.457...

Current Stable Release
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, SQL Compact Edition, 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 all these types of connections depend on your system configuration **

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 
Thursday, May 29, 2014  |  From pk software dev blog - Mini SQL Query

Mini SQL Query Updates... there have been a few, mainly stability etc.


See CodePlex for the download :-)


 


https://minisqlquery.codeplex.com/releases/view/122414

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

 pk software dev blog - Mini SQL Query News Feed 


Sponsored by: http://viridissoftware.com.au/

Last edited May 20 at 10:55 PM by paulkohler, version 35