Table_visualizer Visualize Database Table Connections
This is a tool to visualize all or selected table foreign-key connections of a database. Currently table_visualizer supports MySQL/MariaDB and PostgreSQL databases.
Download: https://github.com/dhamith93/table_visualizer/releases
Usage Visualize full table connections
Command:
./table_visualizer -u root -p password -h 172.17.0.2:3306 -d db_name -s mariadb|mysql|postgres -o filename.jpg # -u : user name # -p : password # -h : host:port # -d : db name # -s : database type [ mysql | mariadb | postgres ] # -o : output file name (jpg) Example output
Creating a Simple Api to Send Sms From Your Android Device Using Python
Background What we are trying to do here is to create a simple python program to connect to the android device using ADB (Android Debug Bridge) and call the SMS service to send a SMS without doing any programming on the Android side. Obviously this is not going to replace a production level SMS service but it can be useful in smaller scale projects.
Prerequisites You should have python installed. And you should download the android platform tools, extract it, and add the path to the path environment variable before we start.
Writing a Command Line Shell for Sqlite With Go
In this guide we are creating a simple command line shell in Golang that would let us create a SQLite DB and run SQL queries in that database. Think of it as a simple version of MySQL CLI application. This is to give you some idea how DB connections in Golang works. Let’s dig in.
Initializing the project First of all, let’s create a directory for our application. I’m going to use *nix commands but you can, however, follow this with Windows using GUI.