Playing with databases doesn't always require installation of full-featured RDBMS. You have probably already come to situation where you need only a small subset of those features. For example, you may only need ability to store your data in relational manner and to use SQL to extract or manipulate that data. Of course, natural choice for this is SQLite - small RDBMS with footprint of only 800 kb. SQLite comes very handy for small databases (e.g. personal collections) where you don't really care about transactions, isolations or other features (although SQLite is ACID compliant). Personally, I use it for my backup management application, in combination with Python. You probably use SQLite every day, even if you are completely unaware of that (for example in Skype, iPhone, Mac OS etc). If you are using Firefox, you are in fact using it right now.
SQLite is an awesome piece of software, but it would be good if you could have some tools to manage your data on the fly, i.e. without using some glue (e.g. programming language) to access and manipulate your data. Fortunately, there is such a software, and you are just few clicks away from using it. Having SQLite embedded in Firefox browser is a great thing. You only need to install a Firefox add-on named SQLite Manager. This add-on allows you to manage any SQLite database on your computer directly through intuitive GUI in Firefox. It also includes features like data import/export (csv and XML), data browsing, ability to create indexes and triggers, DML, DDL, SQL syntax help etc.
You can get this add-on Firefox add-ons page (it works on Firefox 2.0 - 3.0). You can start it by selecting SQLite Manager entry from Tools menu.
SQLite is an awesome piece of software, but it would be good if you could have some tools to manage your data on the fly, i.e. without using some glue (e.g. programming language) to access and manipulate your data. Fortunately, there is such a software, and you are just few clicks away from using it. Having SQLite embedded in Firefox browser is a great thing. You only need to install a Firefox add-on named SQLite Manager. This add-on allows you to manage any SQLite database on your computer directly through intuitive GUI in Firefox. It also includes features like data import/export (csv and XML), data browsing, ability to create indexes and triggers, DML, DDL, SQL syntax help etc.
You can get this add-on Firefox add-ons page (it works on Firefox 2.0 - 3.0). You can start it by selecting SQLite Manager entry from Tools menu.
0 comments:
Post a Comment