My home computers have been getting more and more complicated. I decided to start documenting everything in a Wiki (my memory isn't as good as it used to be). Since there won't be any concurrent users, I don't need anything complicated. I don't want to spend a lot of time setting something up in a relational database. I started searching for Wiki software that uses SQLite. On one of the forum sites that come up on google, I noticed an interesting comment. Someone was searching for Wiki software similar to my needs. Someone else responded with "Why would you want Wiki software that runs on SQLite?" This confused me. Why does everyone want the most "enterprise" software available? This is extra confusing when you think about how much people use Excel instead of a database.
I am a huge fan of SQLite. It is a surprisingly good database technology. It requires no configuration. It is easy to backup. It works great for small installations, like home administration. Imaging being able to unpack a zip file into an apache folder and you are done. You can just go about using the tool.
In my opinion, there is not enough webapps that follow this style. They are non-enterprise tools that have zero-to-no install time. I spend my time using the tools rather and installing/administrating the tools. PHP and SQLite fit into this space very well. There is no need to stand up a JVM. You don't need to create a new database. You don't have to worry about password management. You don't have to worry about keeping a new service up, or starting it on server reboot.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.