Database

MyWebSql is the ultimate desktop replacement for managing your mysql databases over the web. With interface that works just like your favourite desktop applications, you don't need to keep switching over webpages to get simple things done. Just login to your database and manage your database as if your are working on your desktop!

By default the database module supports drivers for MySQL and PDO. The database module is included with the Kohana 3.0 install but needs to be enabled before you can use it. In your application/bootstrap.php file modify the call to Kohana::modules and include the database module

I can't be happy at all if I need to start to mingle with a destroyed SQL query, that person after person added their own little JOIN, or why not a LEFT JOIN there, and then after 5 years somebody is complaining the report x-y-z is slow. MongoDB, embracing the NoSQL swing, delivers a great, fast, and reliable JSON-like storage, written in C++ and is open-source, on Github. Auto-sharding for cloud-level scalability, MapReduce for complex aggregation - you got it! There's a lot of drivers, PHP, Ruby, Python - and cool GUI starting pop out. Check it out! http://www.mongodb.org/ http..

We all use databases to store our data around our applications, storing user settings and data received from client. If you ever had to create a category parent/child relationship in a e-commerce store for instance, this is a very good article explaining both ways and explaining the whole idea and schema of this wonderful way of easily managing a nice tree of categories that you may need for your posts, real-estate properties, products, groups, and so on. Take in mind that this is only intended for a single parent/child approach, one to many.