Posts marked with “JSON”

JSON Schema Validation With MySQL

by · August 6, 2020

0
 

Until recently, there were two schools of thought. Use a traditional relational database with normalized data or a structureless NoSQL database. If you could get avoid designing your database schema and managing table definitions, you could iterate faster and change your application quickly. Schema validation can help you keep an accelerated pace, while still safeguarding […]

 

Querying NoSQL With SQL: HAVING Your JSON Cake and SELECTing It Too!

by ·

0
 

Interested in NoSQL document databases, but discouraged by a lack of a standard query language? Let’s put the SQL back in NoSQL. In this article, let’s explore how a NoSQL document database models data and how SQL can be used to query data without schemas or tables.

 

MySQL Without The SQL—Oh My!

by · July 13, 2018

0
 

Could you be working on a project without a database administrator to set up relational tables, indexes, and schemas? Or are you tired of embedding ugly lines of SQL in your pristine PHP code? There is new hope for you.

 

MySQL Without The SQL—Oh My!

by · July 2, 2018

0
 

Do you work on projects where you begin coding before knowing what your data looks like? Or are you part of the vast majority of developers who have had little or no training in database theory, relational calculus, Structured Query Language, or sets? Could you be working on a project without a database administrator to […]

 

July 2016 – Harnessing Magic

by · July 1, 2016

2
 

The July 2016 issue of php[architect] magazine is ready to download! Some things just work like magic This month we look at regular expressions, cryptography, PHP references, and function programming to help you demystify how they work and add them to your arsenal of solutions. Also in this issue, we look at using the Mailchimp […]

 

June 2016 – Decoupled by Design

by · June 1, 2016

0
 

The June 2016 issue of php[architect] magazine is now available! Less tightly coupled code is easier to debug and re-use. This month we look at techniques to decouple different aspects of your code: including using asynchronous & distributed workers, transducers, middleware, and secure web services. Also in this issue, we have a library to use […]