Free Tools for Editing Plant 3D SQLite Database

Since both Plant 3D and P&ID uses SQLite as a default database, it is good to know some free tools that you can use to edit the database.

[For Geeks only] SQLite is originally developed by D. Richard Hipp back in 2000. It is a self sustaining database in a single file. It works without any process or any services. The only problems with SQLite is when writing to the database. Since it is still a file, no multiple users can write to the database at the same time. The database will be lock when a user start to write to the database and the lock will be release when the writing is done. So it is not encouraged to use SQLite as a database when there are multiple users working on one project.

Here are the free tools:

  1. SQLite Database Browser http://sqlitebrowser.sourceforge.net/ (Simple GUI)
  2. SQLite Expert Personal http://www.sqliteexpert.com/ (Personal version is free and it is by far the most user friendly one)
  3. SQLite Manager https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ (Addons inside Mozilla! Works if you do not have administrator access to install SQLite Expert)

Feel free to post a comment if you have another one that is working for you.


comments powered by Disqus