Building a PostgreSQL Database

  • January 7, 2013 · 6:30 PM

Part 3 of our 4 part class series, those who took July's Sinatra course will learn how to have their code interact with a PostgreSQL database. Taking the prior Ruby and Sinatra courses is recommended, but not required. A basic understanding of Ruby and Sinatra is recommended.


Melissa's not-techi note: If we're thinking about Ruby as the muscles, and Sinatra as the bones, let's go ahead and think of PostgreSQL as the intestines, this is where all the info your program takes in gets processed and sorted.

 

What PostgreSQL website says:

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, andexceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate.

 

January 7 6:30pm - 8:30pm

January 14 6:30pm - 8:30pm

January 21 6:30pm - 8:30pm

January 28 6:30pm - 8:30pm

 

----------------------------------------------------------------------------------

Please note the refund policy: Your payment of $80 guarantees your seat in the entire course. If something changes after registration and you cannot attend the course, you must notify CWD at least 3 days before the first class to receive a refund. If you have to miss a class, we will provide code from class and any slides, but we do not offer partial refunds based on individual class absences.

 

Join or login to comment.

  • Le O.

    Would you be interested in bringing a rotation of this series to Madison or Milwaukee or somewhere inbetween? Looks like a great course and I have several folks interested in learning new programs/skills, including myself. [I'll also check out the web reference, but am in meeting/having some of the Codettes participate.] Code On in the New Year!

    January 5, 2013

    • Melissa P.

      That'd be awesome Le, if you can identify some local coders who'd be interested in helping, we'd love to.

      January 6, 2013

    • Le O.

      Thanks, Melissa. I'll start polling. Meanwhile, Dr. Anita Borg's birthday is the 17th. Systers around the globe around are planning different events. Stay tuned: MeerUp.com/systers. Cheers.

      January 15, 2013

  • A former member
    A former member

    Missed the first one, but wil see you Monday.

    January 11, 2013

  • Diana A.

    Very good and clear explanations. I received very good support. I highly recommend this meetup.

    January 7, 2013

  • shilpi

    What is the complete schedule for this course?

    December 16, 2012

    • Melissa P.

      Classes will be the 7th, 14th, 21st, and 28th from 6:30 to 8:30 each Monday night. We may move classes to the Braintree offices, but otherwise looks good.

      December 18, 2012

  • Maggie

    I'd like to know the full schedule, too. Thanks!

    December 18, 2012

    • Melissa P.

      Classes will be the 7th, 14th, 21st, and 28th from 6:30 to 8:30 each Monday night. We may move classes to the Braintree offices, but otherwise looks good.

      December 18, 2012

  • Melissa P.

    Yes, Elisha, it did. I just replied to your email as well.

    July 29, 2012

  • A former member
    A former member

    Did the dates really change from August to October? I won't be able to attend in October.

    July 29, 2012

11 went

Your organizer's refund policy for Building a PostgreSQL Database

Additional notes: Please note the refund policy: Your payment of $80 guarantees your seat in the entire course. If something changes after registration and you cannot attend the course, you must notify CGD at least 3 days before the first class to receive a refund. If you

Payments you make go to the organizer, not to Meetup. You must make refund requests to the organizer.

Our Sponsors

  • viaForensics

    Sponsored brunch for Django workshop with Chipy.

People in this
Meetup are also in:

Sometimes the best Meetup Group is the one you start

Get started Learn more
Bill

I started the group because there wasn't any other type of group like this. I've met some great folks in the group who have become close friends and have also met some amazing business owners.

Bill, started New York City Gay Craft Beer Lovers

Start your Meetup today

Act now and get 50% off.
Until February 1.

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy