12 July, 2016

NoSQL vs SQL (short version)
By: Matthew Jackson

They both have their advantages. I will list 4 major advantages of each, there may be more but this is the short version.

SQL

  • Relationships. You can easily have two tables linked together with a shared id column. Getting data is easy and changing data means just changing the data in one spot.
  • Maturity. SQL has been used professionally for quite some time and many bugs have been found and fixed. Security holes have been identified and taught how to be beaten. Many times incorporated into
  • ...

Tags: SQL, NoSQL

Read More
15 January, 2015

Prevent Hackers with PHPixie
By: Matthew Jackson

It is important to know when programming how to prevent hacking. Here is another way where PHPixie works great and as expected.It appears to me that PHPixie protects against alot of stanard hacking if used in the proper and expected way:

 

When getting post data, instead of using the standard PHP: $_POST["variable_name"]; (WRONG)

Use PHPhixie:
$this->pixie->post("variable_name");

 

When adding it into the database do NOT use mysql queries... instead use...

Tags: PHPixie, Security, SQL

Read More
1