A database is any organized collection of data organized to provide efficient retrieval.

learn more… | top users | synonyms

14
votes
1answer
14k views

Very simple PHP PDO class

There are many PHP PDO classes out there, agreed. However I find they do not allow for flexibility. So I created one that helps reduce development time as little as it may be but it does the job ...
4
votes
1answer
185 views

In-memory data cache architecture for data transfer

I am writing a cron job to manipulate and transfer remote data. I need to cache data from a table, process it, merge with previous table, iterate the process, and eventually send the result data to ...
20
votes
5answers
4k views

Database connection in constructor and destructor

I am playing with different ways to do database interaction in PHP, and one of the ideas I have been playing with is connecting to the DB in the constructor and disconnecting in the destructor. This ...
5
votes
1answer
613 views

Generic method for database calls

Background Breaking from MVC, I've implemented the following architecture: POST/GET ➤ PHP ➤ Database Calls ➤ XML ➤ XSLT ➤ HTML All database interactions are ...
1
vote
2answers
728 views

SQL database design e-commerce

I am new to database design but am fairly familiar with SQL and its syntax. I want to create a database for an E-commerce website that will sell a single product type such as a shirt. They could be ...
1
vote
1answer
426 views

General code review - PHP/MySQL/MSSQL accessor functions

I've been away from PHP for at least 5 years and I'm just starting to look into it again. I have a set of functions I created and used for database access and I'm wondering if they are still good to ...
2
votes
3answers
131 views

Referential MySql Design

How does this look? It has been over a year since my database concepts class and I have never worked with MySql. I have chosen InnoDB as my engine because of foreign key support using UTF-8 based on ...
2
votes
1answer
469 views

PHP Database class

Below is the code for a Database class that wraps around a small set of the features that the PHP mysqli extension provides. I'm looking for ways to improve its efficiency. Which parts of the code ...
1
vote
0answers
87 views

In-memory data cache architecture

I am designing basic in-memory cache storage with thin CRUD (actually CRD) interface. The design is inspired by the Backend solutions such as Parse and StackMob. Main requirements: Cache consists ...