• Awesome Automated APIs with Automagic REST

    Huntsman Hall at The Wharton School (UPenn)

    Hosted by PostgresPhilly and PhillyPUG at Wharton, Huntsman Hall, room 340. Doors at 5:30pm, pizza around 6pm, presentation shortly after. When you have 60,000 tables and views across hundreds of schemata sitting on top of a 3 petabyte storage footprint, automation and access privileges are key if you want to expose these data through a RESTful API. Wharton Research Data Services (WRDS) leverages PostgreSQL , Python, Django, and Django REST Framework to accomplish this. We are continuing to open source the tools we have built to make this possible! Databases stay relevant by continuing to reinvent themselves to serve new technologies further up the stack. The latest buzzwords further up that stack are APIs and microservices, so prevalent that it is hard to see a tech advertisement that doesn't mention them. While related to "the cloud" and "big data", whatever the heck those terms actually mean, APIs and microservices have a slightly less annoying marketing schtick and more concrete relations to relational databases. But what do these relations look like in practice? In this talk, Timothy Allen of WRDS will show how his team at The Wharton School has evolved from providing financial data exclusively in SAS data formats to a robust backend powered by PostgreSQL, which allows financial research to happen in many ecosystems: still available in SAS, but also R, Python, Perl, Matlab, Julia, and more. He will present a case study of using Django REST Framework to build an "API through introspection." This case study will show how WRDS built a Django web site and RESTful web service by introspecting financial data stored in a PostgreSQL database cluster. The models for the ORM, serializers for the RESTful API, views for presenting the data to a user, filters for refining queries, URL routing, web browsable interface, user token authorization, and permissions, are all handled by introspecting various features of the PostgreSQL database information schema, all with Python. Many of these components have been open-sourced, such as the ability to export an endpoint as a spreadsheet file (XLSX), and a generic automated API builder, called Automagic REST. WRDS is looking for a Python/Django developer and a PostgreSQL developer. If you want to work on an environment like the insanity described above, please contact Tim!

  • PostgresConf Mini: Philly

    Huntsman Hall at The Wharton School (UPenn)

    We are in the middle of the dog days of summer so what's better than ending a long week than an afternoon of PostgreSQL. The doors open at 1:30PM and there will be three presentations as well as snacks, beverages and networking opportunities. See you there! Agenda: • 1:30 - 2:00: Networking, snacks, coffee • 2:00 - 2:10: Jim Mlodgenski - Welcome • 2:10 - 3:00: Bruce Momjian - Will Postgres Live Forever? • 3:10 - 4:00: Mike Freedman - Performant Time-Series Data Management and Analytics With Postgres • 4:10 - 5:00: Payal Singh - Essential Postgres Performance Tuning • 5:00 - 5:30: Lightning Talks • 5:30 - 7:00: Happy Hour (City Tap House)

  • PostgresConf US 2018

    The Westin

    CFP is also open (https://pgconf.org/conferences/2018). Schedule: Monday, April 16 and Tuesday, April 17, 2018, are dedicated to immersive training. Instructors are encouraged to submit half and full day material for consideration. The preferred topics are centered around Postgres but anything data related will be considered. Wednesday, April 18th through Friday, April 20th, 2018 are dedicated to break out sessions, and the Regulated Industry Summit, as well as our inaugural Open Source and Greenplum Summits. The Annual Regulated Industry Summit: “Finance, Government, Healthcare, and Postgres" for discussion on the challenges and solutions in utilizing Postgres in regulated environments. The Open Source Summit is for local Open Source communities with data related technologies such as Python, R and Ruby. The inaugural GreenPlum Summit is a one day summit bringing together the best in Big Data, Massively Parallel Processing (MPP), Machine Learning, Graph, AI and Spatial Analytics centered around the Open Source, Postgres derived Greenplum database.

  • From Startup to Mature Company: PostgreSQL Tips and Techniques

    CandiDate Philly / Industrious Office

    This talk is for people relatively new to PostgreSQL who are wondering: "How do I get going with PostgreSQL -- in a way that won’t create problems later on?" We’ll go over best practices in: • Table design • Indexing • PostgreSQL types • Stored procedures -- when & how to use, when not • Triggers • How to work with a web framework (I.e. Ruby-on-Rails): what works belongs in the framework, what should be done in the database • Error & exception management • Doing the right amount of planning • Why you might want to build the help system first, and use it to help build the rest. Nistica has its ownership in Japan, engineering in New Jersey, & manufacturing in Vietnam so we’ll take a special look at: • Handling different languages & character sets • Timestamps & time zones • How to sync data from one part of the world to another without letting data fall on the floor or creating infinite loopiness. Nistica has gone from startup to world player in the manufacture of optical switches. It has run its manufacturing on PostgreSQL from the start, using PostgreSQL to drive every step from assembly to quality assurance & tracking all part data in the database. Going from the ad hoc procedures appropriate for a startup to the disciplined approaches required by the world market has taught us a lot about how to get the best out of PostgreSQL. We’ve learned a lot from the PostgreSQL community; now we’d like to share some of what we’ve learned from our experience.

  • Automated Failure Management and Caching, with no code changes

    St. Leonard’s Court, Suite 300 (Wharton Computing)

    Implementing database failover and caching requires development work and adds risk. What if there was a solution that removes these complexities? In this session, we wil demonstrate how Heimdall Data is deployed in minutes as a PgPool-II replacement and supports automated caching for improved performance.

  • PostgreSQL Server Side Programming for Javascript Developers

    St. Leonard’s Court, Suite 300 (Wharton Computing)

    One of the great features of PostgreSQL is its pluggable language handler allowing many different types of stored procedure languages including JavaScript aka PL/V8. This allows web developers to leverage their existing coding skills when writing database sever-side code. In this talk we will discuss: • Why someone would want to write server-side code • How to create a PL/V8 function • How to interact with database objects • Returning results back to the application code • Creating event-based functions or triggers

  • Super Meetup 2017

    Uptown BEER GARDEN

    Philly PostgreSQL User Group is partnering with Technical.ly this August for Super Meetup. Join us at Uptown Beer Garden for free drinks and snacks to celebrate the meetup community in Philly (and recruit new members!) Please RSVP here >> Super Meetup 2017" (https://www.meetup.com/Technically-Philly/events... (https://www.meetup.com/Technically-Philly/events/240064727/)­) The Super Meetup is a gathering of the most-connected members of the local tech, startup, and entrepreneurial scene. It’s a chance to make new friends and learn more about local tech and entrepreneurial resources and tech-focused meetup groups. The idea of the Super Meetup is simple: meetups are integral to any tech scene. Every now and then, it makes sense to rally the leaders of tech-related meetups in town and gather for one big mixer. The idea is to connect people with groups they may not have otherwise known about. You can't RSVP here though - you need to go RSVP with Technically Philly who is hosting the event: https://www.meetup.com/Technically-Philly/events/240064727/

  • PGConf US Local: Philly 2017

    Huntsman Hall at The Wharton School (UPenn)

    Join the PostgreSQL community in Philadelphia on July 13th and 14th 2017 for two days of fantastic PostgreSQL content. July 13th will contain trainings and July 14th will be breakout sessions. Registration is now open at the link below. You MUST register at the conference site to attend. https://www.pgconf.us/conferences/Philly2017 PGConf US (https://pgconf.us/conferences) Local events are designed to bring comprehensive educational content and networking opportunities to the "local" PostgreSQL community where the event is being held. They are perfect opportunities to show support for PostgreSQL, find leads and build relationships with other professionals and companies using and support PostgreSQL.

  • WEST - Postgres Window Magic


    Normal SQL queries return rows where each row is independent of the other returned rows. SQL window functions allow queries to return computed columns based on values in other rows in the result set. This presentation explains the many window function facilities and how they can be used to produce useful SQL query results. About the Speaker Bruce Momjian is a co-founder of the PostgreSQL Global Development Group and has worked on PostgreSQL since 1996 as a committer and community leader. He is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Bruce is employed by EnterpriseDB as a Senior Database Architect.

  • PGConf US 2017

    The Westin Jersey City Newport

    Please sign up for this event at http://www.pgconf.us PGConf US 2017 is the largest PostgreSQL conference in North America and is taking place March 28-31, 2017 in Jersey City, New Jersey. PGConf US 2017 will feature an expanded familiar three-day conference format on March 29 - 31 with a mix of specialized sessions, keynotes, and the ability to connect with PostgreSQL fans at various receptions throughout the day. As with past PostgreSQL conferences, we will feature presentations from the perspective of developers, DBAs, systems administrators, business-intelligence analysts, and decisions makers. Check out the schedule at: http://www.pgconf.us/conferences/2017 Regulated Industry Summit The "Third Annual Regulated Industry Summit: Finance, Government, Healthcare, and PostgreSQL" is a community summit hosted at The Westin Jersey City Newport that brings together PostgreSQL contributors and enterprise developers to discuss challenges and solutions in utilizing PostgreSQL in regulated environments. http://www.pgconf.us/conferences/2017 Training If you want to learn even more about PostgreSQL, on Tuesday March 28, we will be conducting special training sessions. Sign up for 1 or 2 of them today. • Linux IO internals for PostgreSQL administrators by Ilya Kosmodemiansky • PostgreSQL When It's Not Your Job by Christophe Pettus • Designing a Multi-tenant Database for Scale with PostgreSQL by Ozgun Erdogan • Getting Stuff done with PostGIS by Leo Hsu and Regina Obe • (SOLD OUT) Detecting performance problems and fixing them by Hans-Jürgen Schönig • Pacific Crest Trail: The postgresql.conf from A-Z by Joshua D. Drake The seats for the training classes are limited and can be purchased at: http://www.pgconf.us/conferences/2017 Tickets You can get your tickets at: http://www.pgconf.us/conferences/2017#registration (http://www.pgconf.us/conferences/2017#registrationReach) Reach out to our sponsors for a special discount code. Also, if you really want to make it to the conference but can't seem to break away from work for the week, this year we are offering Day Passes. Take a look at the schedule and try to decide which day you want to see and register for a single day. Job Fair If you are looking for your next opputunity, bring your resume and come check out the 1st annual PostgreSQL Job Fair. The PostgreSQL Job Fair is free and open to the public Friday March 31, 2017 from 12:00-3:00. Sponsors • Diamond: Amazon Web Services • Platinum: OpenSCG, EnterpriseDB, 2ndQuadrant • Gold: Heroku, Crunchy Data, GridGain, Braintree, JetBrains, Google Cloud Platform, Select Star, Airfacts