Archive for the ‘Database’ Category

How to Search on Securely Encrypted Database Fields

Posted on: No Comments
We [ParagonIE] get asked the same question a lot (or some remix of it). This question shows up from time to time in open source encryption libraries' bug trackers. This was one of the "weird problems" covered in my talk at B-Sides Orlando (titled Build...

How to Synchronize WordPress Live and Development Databases

Posted on: No Comments
Developing WordPress themes is considerably easier with real content. Unexpected situations begin to arise when people add pages, posts, media and comments. Your beautiful template can break when: editors use assets which are too big or small for your...

Using GDELT 2 with PHP to Analyze the World!

Posted on: No Comments
Are you interested in political world events? Do you want to play with one of the world's largest databases? If you answered either of those questions with a yes, keep reading - this will interest you! This article follows up on the promise to use GDEL...

Quick Tip: The Convenient Magic of Eloquent Observers

Posted on: No Comments
If you've used Eloquent on medium to large projects before, you may have encountered a situation where you want to take action when something happens to your models. Eloquent provides a convenient way to do so. The Observer Pattern The observer patte...

Beaver in Action: Practical MySQL Optimization

Posted on: No Comments
Clients with an existing application sometimes ask me to fix bugs, improve efficiency by speeding up the application, or add a new feature to some existing software. The first stage of this is researching the original code – so-called reverse enginee...

Extending OctoberCMS – Building a Soft-Delete Plugin

Posted on: No Comments
Developers usually stick with a new CMS for its simplicity and extensibility. OctoberCMS presents itself as a back to basics CMS, and provides an enjoyable experience for both developers and users. In this article, I'm going to demonstrate some aspects...

A First Look at Atlas – the ORM That Delivers

Posted on: No Comments
"AtlasORM is a data mapper implementation for your persistence model (not your domain model)" By definition, a Data Mapper moves data between objects and a database and isolates them from one another. With a Data Mapper, the in memory objects don't e...

How to Create a Pokemon Spawn Locations Recorder with CouchDB

Posted on: No Comments
In a previous article, you’ve been introduced to CouchDB. This time, you’re going to create a full-fledged app where you can apply the things you learned. You’re also going to learn how to secure your database at the end of the tutori...

A Pokemon Crash Course on CouchDB

Posted on: No Comments
In this tutorial, we'll walk through working with CouchDB, a NoSQL database from Apache. This tutorial will focus more on the practical side, so we won't cover what CouchDB is good for, how to install it, why use it, etc. We'll focus on how to perform ...