momjian.us

pinaraf.info

Review – “Instant PostgreSQL Starter” | Pinaraf's website

http://www.pinaraf.info/2013/05/review-instant-postgresql-starter

Review – “Instant PostgreSQL Starter”. May 23, 2013. Thanks to Shaun M. Thomas. I have been offered a numeric copy of the “ Instant PostgreSQL Backup. 8221; book from Packt publishing, and was provided with the “ Instant PostgreSQL Starter. 8221; book to review. Considering my current work-situation, doing a lot of PostgreSQL advertising and basic teaching, I was interested in reviewing this one…. So, what’s inside? I’d say what you need to kick-start with PostgreSQL. To sum up my point of view about thi...

pinaraf.info

March | 2013 | Pinaraf's website

http://www.pinaraf.info/2013/03

Monthly Archives: March 2013. My-post-engine : a postgres-engine for MySQL. March 31, 2013. For a while, I’ve been trying to push some people toward PostgreSQL. It covers their use-cases better than MySQL, should provide greater performance, and should help me keep the hairs on my head. But most of the time, they are relunctant unless they can really try it. Sadly, when you have huge databases, huge piece of code depending on the MySQL behaviour, you’re in a dead-end. How does it work? CREATE TABLE `todo...

pinaraf.info

Review – “PostgreSQL Server Programming” | Pinaraf's website

http://www.pinaraf.info/2013/07/review-postgresql-server-programming

Review PostgreSQL Server Programming. July 24, 2013. Two months ago, I reviewed the Packt Publishing book “Instant PostgreSQL Starter” . And two weeks ago, Packt Publishing offered me to review their latest PostgreSQL book, PostgreSQL Server Programming. Now that we know what this book is not about Let’s have a look at the table of contents. The book is structured in 10 chapters. The two following chapters cover two must-have for server-side programming. The triggers are probably the key feature of serve...

unfetteredblather.wordpress.com

Anatomy of a FOR loop – part 1 | Unfettered Blather

https://unfetteredblather.wordpress.com/anatomy-of-a-for-loop-part-1

Anatomy of a FOR loop part 2. Anatomy of a FOR loop – part 1. August 1, 2010 by korryd. The FOR loop is one of 10 control-of-flow statements in PL/pgSQL (the others being IF, CASE, LOOP, WHILE, EXIT, CONTINUE, BREAK, RETURN, and RAISE). Most of us are familiar with two or three of the most common ways to write a FOR loop, but few of use have explored all of the subtleties of this humble statement. The general form of the FOR loop is:. Start-value . end-value. END LOOP [label];. If you have assigned a lab...

pinaraf.info

PostgreSQL | Pinaraf's website

http://www.pinaraf.info/category/postgresql

Blogs related to PostgreSQL. Modern C stored procedure wrapper. February 1, 2015. In a application following an intelligent database design. Calls to stored procedures happen very often and thus must be done with as little boilerplate as possible. Usually frameworks abstracting calls to the database are just ORMs, ignoring completely stored procedures, making the database stupid and moving all the logic in the application. A stored procedure can be called using a few lines of interface :. SqlBindingMappe...

pinaraf.info

My first PostgreSQL patch/hack | Pinaraf's website

http://www.pinaraf.info/2013/06/my-first-postgresql-patchhack

My first PostgreSQL patch/hack. June 17, 2013. After almost two years of lobbying at work to promote PostgreSQL instead of MySQL, after two years of tears against poor DB typing, lack of advanced SQL features, traps in what seemed like basic needs (select * from myview where a=5, if myview is not simple, triggers a full scan on the view result) we are finally starting to deploy some PostgreSQL databases. And let’s share also how I did the patch to highlight how easy patching PostgreSQL is. Well, only one...

pinaraf.info

May | 2013 | Pinaraf's website

http://www.pinaraf.info/2013/05

Monthly Archives: May 2013. Review – “Instant PostgreSQL Starter”. May 23, 2013. Thanks to Shaun M. Thomas. I have been offered a numeric copy of the “ Instant PostgreSQL Backup. 8221; book from Packt publishing, and was provided with the “ Instant PostgreSQL Starter. 8221; book to review. Considering my current work-situation, doing a lot of PostgreSQL advertising and basic teaching, I was interested in reviewing this one…. So, what’s inside? I’d say what you need to kick-start with PostgreSQL. To sum u...

pinaraf.info

February | 2015 | Pinaraf's website

http://www.pinaraf.info/2015/02

Monthly Archives: February 2015. Modern C stored procedure wrapper. February 1, 2015. In a application following an intelligent database design. Calls to stored procedures happen very often and thus must be done with as little boilerplate as possible. Usually frameworks abstracting calls to the database are just ORMs, ignoring completely stored procedures, making the database stupid and moving all the logic in the application. A stored procedure can be called using a few lines of interface :. SqlBindingM...

pinaraf.info

PostgreSQL | Pinaraf's website

http://www.pinaraf.info/tag/postgresql

Modern C stored procedure wrapper. February 1, 2015. In a application following an intelligent database design. Calls to stored procedures happen very often and thus must be done with as little boilerplate as possible. Usually frameworks abstracting calls to the database are just ORMs, ignoring completely stored procedures, making the database stupid and moving all the logic in the application. About a simple system built using Java and the Java annotation and reflection system. And this will display 3.