PHP Classes

Notable PHP package: Scripd

Recommend this page to a friend!
  Blog PHP Classes blog   RSS 1.0 feed RSS 2.0 feed   Blog Notable PHP package: ...   Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)  

Author:

Viewers: 319

Last month viewers: 1

Categories: Notable Packages

Every SQL database driven application needs to update the database schema once in a while to support new features.

This class can perform that process of generating SQL for database updates with elegance, as it allows developers to defined database schema additions in a JSON based file format, so it can work with different types of databases.

Since the format is based in JSON it can be used eventually by similar packages written in other languages.

Not only it supports the creation and modification of databases, tables and indexes, but it also supports triggers, views, stored procedures and functions.

Read this article to learn more details about how this notable PHP package works.




Loaded Article
The package Scripd is one of the few PHP packages that was considered notable recently because it does something that is worth paying attention.

The basic purpose is: Generate database creation SQL queries from JSON

Here follows in more detail what it does:

This package can can generate database creation SQL queries from JSON.

It takes a file in JSYN format (JSON) and parses it to extract a list of commands for database creation.

The main class can generate SQL queries for creating or modifying database structures like databases, tables, views, indexes, trigger, functions, stored procedures, etc..

The generated SQL is compatible with several databases like MySQL, SQLite, Microsoft SQL server, etc..

Notable PHP packages can be often considered innovative. If this package is also innovative, it can be nominated to the PHP Innovation Award and the author may win prizes and recognition for sharing innovative packages.

If you also developed your own notable or innovative packages consider sharing them, so you can also earn more visibility for your package.



You need to be a registered user or login to post a comment

Login Immediately with your account on:



Comments:

No comments were submitted yet.



  Blog PHP Classes blog   RSS 1.0 feed RSS 2.0 feed   Blog Notable PHP package: ...   Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)