sqlite over libgda

I have learnt

* DDL ( data definition language ) varies from one implementation to another.

* it is easier and faster to maintain for one (database) backend , rather than across many.

* libgda is good when you are designing a application to manage databases.

* libgda is an overkill, when all you need to do is to maintain a small database.

* sqlite is fast, small, well documented, and has an active support over irc.

* to restrict db related code to as few files as possible.

* sqlite is an excellent resource to look up implementation of ".import" command.

* using git ( or any othe vcs ) saves a lot of time.

Comments

Post a Comment

Popular posts from this blog

phpipam behind a load balancer which handles ssl offloading

phpipam has support for ssl offloading, via  X-Forwarded-For  header .   public function createURL () {                 # reset url for base                 if($_SERVER['SERVER_PORT'] == "443")            { $url = "https://$_SERVER[HTTP_HOST]"; }                 // reverse proxy doing SSL offloading                 elseif(isset($_SERVER['HTTP_X_FORWARDED_PROTO']) && $_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https')      { $url = "https://$_SERVER[SERVER_NAME]"; }                 elseif(isset($_SERVER['HTTP_X_SECURE_REQUEST'])  && $_SERVER['HTTP_X_SECURE_REQUEST'] == 'true')        { $url = "https://$_SERVER[SERVER_NAME]"; }                 // custom port                 elseif($_SERVER['SERVER_PORT']!="80")           { $url = "http://$_SERVER[SERVER_NAME]:$_SERVER[SERVER_PORT]"; }                 // normal http Unfortunately, some don't foll
Read more

recovering LUKS encrypted Ubuntu LV Group when mounting on a different Ubuntu system

I mirror my hdd, and keep swapping them in and out of test system. Often I mirror ( using external dock, such as - http://www.ebay.in/itm/Anker-Uspeed-USB-3-0-and-ESATA-To-SATA-External-Hard-Drive-Docking-Station-/161201311080 ). This leads to an issue.  Ubuntu during installl with luks+lvm configuration will name the vg as "ubuntu--vg". And when you plug in another drive on which ubuntu was installed, would lead to a naming conflict and failure to activate the lvm after luks open. ) Ubuntu will give you a passphrase dialog when you plug the device in (if you're in a gui) but will fail to mount after the password is entered. The reason for this is that the volume group of your old partition, and your current OS partition are the same. However, if you enter the password, it will still create a node in /dev/mapper/. If you run ls -la /dev/mapper/ you should see a luks-xxxxxx-xxxxx-xxxx or some such file. That's the mapping that was created when the password di
Read more