Download the PHP package threeletters/supersql without Composer

SuperSQL

A light, efficient and powerful php sql database framework. Allows you to quickly and securely develop anything using SQL databases.

Purpose

1. To provide a very fast and efficient way to use SQL databases.
2. To provide an easy way to use SQL databases safely.

Main Features

1. Very small - 27.4KB one file (Unminified, dist/SuperSQL.php. Minified version: 12.4KB)
   • You can also choose whether you want an optional helper class.
2. Simple and easy - Very easy to learn. SuperSQL was designed to be easy and simple, to the point that a noob can use it.
   • Straight forward syntax is db->select("table");
   • String syntax is standardised. Its allways '[operator1][op2][op3...]column[alias][type]'=>value
3. Compatability - Supports all major SQL databases
   • Uses the PDO API for widespread support
4. Efficiency - This module was built with speed and efficiency in mind.
   • Internal optimizations to make sure there is little overhead as possible
   • Dynamic SQLResponse class so you only fetch a row when you use it ($response[0] will only fetch the first row)
5. Complexity - This module allows you to make all kinds of complex queries.
   • Multi-table queries to execute queries on multiple tables at once
   • Multi-value queries to execute queries with multiple values
   • Templates to pass sets of data in as a group
   • Type casting and aliases
   • DISTINCT, GROUP, LIMIT/OFFSET, INSERT [INTO], and more supported
   • Raw input available
6. Security - This module prevents SQL injections, so hackers bye bye!
   • Uses PDO's prepare/bindParam/execute system with types
7. Availability & Integration - This module is FREE. Licensed under the MIT license.
   • Use it as you wish! Only remember to give credit.
   • Also available on composer

Usage

You may either

1. Use the built file (/dist/SuperSQL.php - preferred)
2. Use the library (Autoload all in SuperSQL/, we also provide a simple loader)
3. Use the composer package (composer require threeletters/supersql)

Build

To build this library, you need NodeJS. Then execute builder.js

node builder.js

It will build to /dist/SuperSQL*.php

Documentation

Full documentation is here: https://threeletters.github.io/SuperSQL

FAQ

What is a SQLResponse?

SQLResponse is the object returned from a query. It implements the ArrayAccess and Iterator interfaces, and so can be accessed and iterated through like an array. When you do access a row or iterate through, a function is called and fetches the row from the database, and caches it. If all rows are fetched, then the connection is deleted as it does not have to be used anymore.

Whats the difference between this and Medoo?

While on the most basic level, SuperSQL and Medoo are the same, they are quite different.

• Response class - SuperSQL has a response class to access crucial information, such as errors
• Helper - SuperSQL comes with an optional advanced helper class, with helper functions, while medoo has a simple one built right in.
• Smaller & lightweight - SuperSQL is smaller than Medoo, yet has more features.
• Development - SuperSQL's code is well structured and it is commented - so you can understand it more
• SuperSQL is faster - Using xdebug, we found that superSQL's parser is faster than medoo's. (x1000,100%)
• SuperSQL is less confusing. (EG, SELECT * FROM `table` is just $SuperSQL->select('table');)
• SuperSQL has more features - (EG, multi-querying, dynamic responses, distinct, etc...)

How fast is superSQL compared to Medoo?

speed

Whats the difference between this an SlickInject?

SuperSQL uses the same concepts and design as SlickInject. However, SuperSQL has more complex features.

Why use PDO instead of Mysqli?

PDO is much more versatile than mysqli. Main reason is because it supports so many different databases while mysqli only supports one.

How did you make the documentation?

The nice documentation was created using Slate - Check it out.

Special thanks

• @LegitSoulja - SlickInject,
• @catfan - Medoo
• Slate (Documentation)

Contributing

Contributing is open. If you want to contribute, make a pull request. Please use the PEAR format.

NOTE: please do not do [] for array. Please use array() instead. This is for backwards compatability.

License