Archive for the ‘Database’ Category

Introducing the Neo4j Symfony Bundle

Posted on: No Comments
There is no such thing as disconnected information, no matter where you look - people, events, places, things, documents, applications and the information about them is all heavily connected. As the volume of data grows, so does the number and dynamici...

Re-Introducing Eloquent’s Polymorphic Relationships

Posted on: No Comments
You've probably used different types of relationships between models or database tables, like those commonly seen in Laravel: one-to-one, one-to-many, many-to-many, and has-many-through. But there's another type of relationship that's not so common: po...

Using MySQL with Node.js & the mysql JavaScript Client

NoSQL databases are all the rage these days and probably the preferred back-end for Node.js applications. But you shouldn't architect your next project based on what's hip and trendy, rather the type of database to be used should depend on the project'...

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...