Best Database Tools Scripts for Web

PgHero can show a small status review for a desired PostgreSQL database. This is done via a Web-based interface where admins can go and check out how their database is being used. Admins can view a list of recent queries, current indexes, the disk space...

Prom allows Python developers to interact with a PostgreSQL database via Python-specific syntax.This in turn allows developers more in-depth control over the database, even if their SQL skills aren't really that good.Prom was based on Mingo.Prom usage...

Sometimes developers prefer using ORMs or query builders to run SQL operations.This is mainly because of SQL's complicated syntax and the different way each database engine interprets it.Squel.js allows developers to use JavaScript syntax to write their...

Apache Sqoop is a must-have tool for every database administrator, letting them easily move data between the Hadoop NoSQL database to more classic database systems like PostgreSQL, MSSQL, MariaDB, or MySQL - a.k.a. relational databases.Sqoop basically...

Apache OpenJPA comes in two separate branches, each production level material.The differences between the two are the standards they implement. The 1.x branch follows the JSR-220 Enterprise Java Beans 3.0 specificationm while the 2.x branch was modeled...

MongoDB is a powerful and very used document-oriented NoSQL database, perfect for high traffic and intensive load environments.Since this is a relative new database, working with MongoDB has always been a little difficult, mainly because of its CLI-based...

Neo4j is a high-performance graph engine with all the features of a mature and robust database.It is a data store that falls into the boundaries of a NoSQL database system.The project provides support for the Graph Export Object File Format (GEOFF),...

Sequelize works on the principle of mapping database entries to JS objects and vice versa. This is because JS objects are very well documented and JavaScript itself was modeled to deal with array structures much better than with SQL tables. This enables a...

Riak is a distributed, decentralized data storage system. Riak is written in Lisp and simplifies development by allowing developers the ability to quickly prototype, test, and deploy database-enabled applications.The client can connect to Riak by two...

The users running Cassandra 0.6.x series should use pycassa 0.3.0, users using the 0.7.x series can use the newer versions.Features:Auto-failover support Support for single or thread-local connections Connection pooling Thrift interface Batch interface A...