In this Episode Eric, John, and Oscar discuss the August 2020 issue, Data Discipline. Topics Covered Using SQL with non-relational databases. Data integrity with UUIDs and primary keys. Connecting and working to databases directly. Rolling dice with PHP Thinking about data types. Using Windows or Linux as your daily driver.

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 […]

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.

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.

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 […]

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 […]

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 […]