Sql client for mysql, sqlite, postgresql, access and mssql databases
- Sessions
- Autocompletion
- Query history
- Join helper
- Data analysis tools: xy plot, distribution plot
- Query result to sql expression converter
Main window
Join helper
Data import
-
Clone sources (in git bash run
git clone https://github.com/mugiseyebrows/mugi-query.git
) -
Install
MSVC 2019
compiler (Download Visual Studio Community and checkMSVC vxxx for VS 2019 for x64 or x86
andSDK for Windows 10
in installer's components tab). -
Install qt5 from www.qt.io (you need qt account for that, sorry) (check latest
Qt\Qt 5.x.x\MSVC 2019 64-bit
and leaveDeveloper and Designer tools
as it is (Qt Creator, Debugging tools, cmake, ninja
checked)) -
Download qwt from sourceforge.net
-
Unzip
qwt-6.1.4.zip
to some temporary directory -
Apply patch (in git bash navigate to qwt-6.1.4 parent directory and run
patch -p1 -ruN -d qwt-6.1.4 < path\to\mugi-query\src\qwt-6.1.4-msvc2019.patch
) -
Build and install qwt using guide in
qwt-6.1.4/doc/html/qwtinstall.html
-
Open
mugi-query.pro
in QtCreator and build project (assuming you have toolchain configuredTools -> Optioins -> Kits
).
In terminal run
# installs qt5 and build tools
sudo apt install git build-essential qtbase5-dev qtchooser
# installs qwt and dependencies
sudo apt install libqwt-qt5-dev libqt5svg5-dev
# installs sql plugins
sudo apt install libqt5sql5-mysql libqt5sql5-odbc libqt5sql5-psql libqt5sql5-sqlite libqt5sql5-tds libqt5sql5-ibase
git clone https://github.com/mugiseyebrows/mugi-query.git
cd mugi-query
qmake -qt=5 'CONFIG+=release'
make
make clean
strip mugi-query
sudo make install # installs to /usr/local/bin
python desktop.py # copies icons, creates desktop file