Tagged Questions
1
vote
0answers
78 views
Designing a universal database driver class
I have a homebrew MVC framework that I have been using for a while, and it has been working great, but I am planning an upgrade to it for its ORM classes. So far, it only supports SQL databases by ...
8
votes
4answers
346 views
Should database queries be abstracted out of the page itself?
When writing page generation in PHP, I often find myself writing a set of files littered with database queries. For example, I might have a query to fetch some data about a post directly from the ...
1
vote
1answer
330 views
Registration: Email hash and verifying only one account per email
I'm using a registration function that hashes the email in PBKDF2 with a random and unique Salt each time. The hashes email and his salt are saved in the DB. No problem with that.
The problem is that ...
0
votes
0answers
64 views
Language Certifications [duplicate]
Possible Duplicate:
Are certifications worth it?
Are there any recognized certifications for any programming languages, specifically PHP, JavaScript, SQL and Objective-C that are worth ...
2
votes
2answers
147 views
Better way to search for text in two columns
Here is the scenario. I am making a custom blogging software for my site. I am implementing a search feature. It's not very sophisticated - basically it just takes the search phrase entered and runs ...
2
votes
1answer
305 views
Which would be a better way to load data via ajax
I am using google maps and returning html/lat/long from my MySQL database
Currently
A user picks a business category e.g; "Video Production".
an ajax call is sent to a CodeIgniter controller
the ...
4
votes
4answers
821 views
What are the advantages to using SQL query builders?
Are there any advantages to using a query builder, rather than using raw SQL?
E.g.
$q->select('*')
->from('posts')
->innerJoin('terms', 'post_id')
->where(...)
vs:
SELECT * FROM ...
3
votes
2answers
1k views
How can I design a model layer without ORM, and when should I use it?
I'm a PHP developer who started with CodeIgniter. In it, designing models was easy: it seemed like each method defined in models was the equivalent of static methods in a normal, objected-oriented ...
0
votes
2answers
236 views
Programming certificates [duplicate]
Possible Duplicate:
Are certifications worth it?
I'd be glad to hear your opinions on which programming certificates are the most widely recongnized in the industry and how useful are they ...
12
votes
6answers
1k views
Interacting With Data Using Multiple Databases/Servers
All of the projects that I've had to deal with so far have only required a single database on a single server. I'm interested in learning more about how projects that need to scale move to multiple ...
3
votes
3answers
576 views
Why put SQL statement in a variable before using mysql_query()?
I'm been working with PHP on and off for a bit now, and I've seen plenty of code both ways:
$sql = "SELECT …";
mysql_query($sql);
vs
mysql_query("SELECT…");
Is there a reason for separating the ...
0
votes
3answers
108 views
Trying to evaluate answers provided by an online technology school
I've been considering taking some web-related programming courses from an online technology school (it's probably best if I don't name names). When I read the syllabi of the different courses on their ...
7
votes
1answer
339 views
How to document an algorithm properly with sample data?
I am wondering what should an algorithm documentation contain? Can't locate a proper guideline to follow. I have in mind to include
summary of the algorithm
description of the algorithm
flowcharts
...
2
votes
1answer
278 views
Active Record library with support for both SQL and NoSQL?
I'm looking for a PHP Active Record library that supports both SQL and NoSQL drivers (mongodb in particular). It doesn't matter if it actually has the NoSQL driver, I can write it myself, as long as ...
8
votes
6answers
615 views
What kind of Web development projects benefit from using ORM?
I'll start by saying that I've done 95% of my database work using SQL. Recently, I did some investigation of various ORMs, such as NHibernate and Doctrine.
I can see the advantages of not needing to ...
