The act of converting content from its original format into a format capable of being displayed on the web
Manage Multiple WordPress Sites

SQL

SQL Category

SQL Query String Builder for JS — Squel.js

Squel.js is a library for building SQL query strings.

squel SQL Query String Builder for JS    Squel.jsSquel.js is lightweight and works with Node.js or in the browser. The library is well-tested and supports the default methods, such as SELECT, INSERT, DELETE and others.

While Squel.js is great client-side, you shouldn’t use the library for browser-side query management, as it massively increases your chances of being hacked.

 

Understand & Visualize Relationships in Data — Induction

Induction is a “polyglot database client for Mac OS X”.

This tool is meant to aid the understanding and exploring of data.

induction Understand & Visualize Relationships in Data    InductionInduction supports the following databases as of now: PostgreSQL, MySQL, SQLite, Redis, and MongoDB. You can also write your own extensions for your preferred database types.

The tool is still in an alpha, but a roadmap has it that it’ll have many more features soon enough.

 

Database Version Control For Teams — dbv.php

dbv.php is an application for ensuring that the local databases of developers working in teams are in sync.

dbv Database Version Control For Teams    dbv.php

Once installed, DBV tracks changes in the databases (MySQL is supported by default) and, once a change is uploaded, notifies the version control system. Think of it as a hub of sorts for various databases.

Easy User Authentication & Management — AuthManager

AuthManager is a PHP script for user authentication via Facebook Connect, as well as user management.

authmanager Easy User Authentication & Management    AuthManagerThe extensive tool features authentication, spam protection, a configuration panel, user access logs, and much, much more. This is indeed a full-blown system for user management.

AuthManager can be a bit tricky to implement with other frameworks, but it might well be worth the effort — AuthManager is a splendid tool that’ll definitely save you time when writing the next website.

Rule the Seven Internet Seas – Fork CMS

Fork is an open-source CMS with an intuitive interface and pretty themes.

poseidon Rule the Seven Internet Seas   Fork CMSThe CMS comes packed with several awesome features:

  • User-friendly UI;
  • Powerful applications;
  • Marketing-friendly structure (Google Analytics is easy to integrate, etc.) ;
  • Awesome themes.
Although the correct term for the fork-like thing that Poseidon – or Neptune, same thing, really, — holds is a trident, Fork CMS does sound a lot better than Trident CMS. :)

orientDB: noSQL document database light, portable and fast

OrientDB is an Open Source DBMS that comes out with both features of Document and Graph DBMSs.

graphed tutorial graph small orientDB: noSQL document database light, portable and fast

OrientDB is developed in Java and it’s a NoSQL DMBS. This means that you don’t need to learn a new language even if it supports a subset of SQL as query language.

OrientDB is very fast; it can store up to 150k records per second on common hardware. Even if it’s Document based database the relationships are managed as in Graph Databases with

direct connections among records.