Close
Glad You're Ready. Let's Get Started!

Let us know how we can contact you.

Thank you!

We'll respond shortly.

LABS
Learning to Count with PostgreSQL

Interestings

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

http://www.postgresql.org/docs/9.1/static/tutorial-window.html

  • Good article on quick Twitter Bootstrap style customizations

Some good links and resources in this article, including a sweet color scheme generator, FontAwesome, Kickstrap, and more.

Events

  • Wednesday: Enyo Bootcamp

Come to the Enyo Bootcamp workshop to learn everything you need to know to begin creating cross-platform cross-browser Web applications with this exciting framework. There will be a brief presentation followed by Q&A with some of the Developer Relations Engineers. Attendees should be somewhat familiar with HTML, JavaScript, and CSS to get the biggest benefit. Visit http://enyojs.com/ to get a leg up or come prepared to have your mind blown.

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/

Comments
Post a Comment

Your Information (Name required. Email address will not be displayed with comment.)

* Copy This Password *

* Type Or Paste Password Here *