- PostgreSQL COUNT(*) OVER()
Sometimes when you’re paginating you have to run 2 queries, one for the first n records, and another for the total count.
It’s possible to get both in one query using OVER().
SELECT , COUNT() OVER() as total_count FROM blog_posts ORDER BY created_at DESC LIMIT 25;
Each record will come back with a total_count attribute, so you will have to look at one of the records to figure out the count.
- Good article on quick Twitter Bootstrap style customizations
- Wednesday: Enyo Bootcamp
To get into the spirit of working with the framework, read about Xtuple’s recent experience at http://www.xtuple.org/node/5000 and be inspired by the ease of Enyo!
Eventbrite Invite: http://enyobootcampnewyorkcity.eventbrite.com/