Create a SQLite Database While Building a Docker Image
Do you need to have a SQLite database available in a Docker image? I did, and here’s the solution I came up with.
Database Articles and Tutorials
Fix the SQLite "attempt to write a readonly database" error
If you’re encountering "General error - 8 attempt to write a readonly database" when working with SQLite, and confused because the write permission’s set on the file, here’s the solution.
3 Simple Ideas for Improving Zend Framework Performance
Here’s 3 simple ideas for improving Zend Framework 2 application performance without learning more code. Think Database
Zend\Db\Sql\Select - The Basics (Columns, Limit & Order)
In part 3 of this series on \Zend\Db\Sql\Select in Zend Framework 2 We cover the constructor, columns function, aliases and expressions, finishing up with limit and order functions. Come wind up the series in style.
\Zend\Db\Sql - Creating Joins and Unions with Ease
In part two of the \Zend\Db\Sql\Select series, we create inner, outer, left and right joins as well as union queries with ease. Come learn more about building queries simply, effectively and easily in your every day applications with Zend Framework 2.
\Zend\Db\Sql - Build SQL Where Clauses Easily and Efficiently
In this tutorial we’re working through the basics of \Zend\Db\Sql\Where, showing how to build SQL Where clauses for database queries. We’ll show how to create different predicates from simple to nested queries using of and, or, like, between and in conditions.