Search for a command to run...
Database IDE > SQLite3 Managers/Browsers
I have over 40 years of programming experience using a variety of languages over the course of my career to develop real-time solutions for real-world problems.
Keyboards connect us to the world and, as a keyboard enthusiast, I am searching for the ideal keyboard.
No comments yet. Be the first to comment.
In this series I delve into the world of MQTT (Message Queuing Telemetry Transport) using Tcl/Tk.
MQTT - Message Queuing Telemetry Transport Curiosity often leads to unforeseeable tangents. MQTT, the messaging and data exchange protocol of the IoT, caught my attention. MQTT was first invented in 1999 and gave rise to the current wave of IoT. I...
Looking at an article for the book “Gist of Go: Concurrency,” I also stumbled across a reference to “High-precision date/time in SQLite” written by the same author, Anton Zhiyanov. I use SQLite in man
Happy 10th Anniversary - RUST!
Login failed. It appears you are offline
Modern Fortran: Tricks of the Software Engineering Trade by Damian Rouson Sometimes I think I'm one of the few programmers routinely using Fortran long after my Engineering studies too many years ago. As such, I'm pleasantly surprised when a new book...
Make GIT a Habit
Tcl's MQTT Broker requires SQLite3 to create and manage the database to support it. Although knowing SQLite3 is not a prerequisite for using the broker package, it is helpful to see what is happening behind the scenes while the broker is working.
While the SQLite library is very easy to use from Tcl, I continue to use several database managers for SQLite depending on my needs at the time. I use SQLiteManager for simple applications and it will certainly serve our purposes here.
I also use Navicat 15 and recently upgraded to Navicat 16 for a variety of databases including SQLite. DataGrip by JetBrains is my database manager of choice as it supports multiple relational databases and is better suited for more complex schemas.
I recently downloaded DBeaver Ultimate Edition for trial purposes. It carries an impressive list of features and may be worth further consideration in the long run. However, the price tag for this version is quite steep when compared to other options.
Devising an SQLite client/browser using Tcl is not necessarily a difficult task, but why reinvent the wheel when so many tools are already freely available. Visit "The Tcl interface to the SQLite library" page for more information on using the SQLite library from Tcl or Tcl/Tk scripts.
I typically use Microsoft's SQL Server Management Studio when working with SQL Server. However, DataGrip is my preferred Database IDE.