This month's topic: Writing a Database Application Without Knowing a Word of SQL (a.k.a. POJOs, JPA, and ORM)

We will discuss building a Java Swing application (installed or web start) that saves its data POJOs (Plain Old Java Objects) into SQL databases across the net (mySQL) or to a local embedded database (Derby) by using the JPA (Java Persistance API) and ORM (Object Relational Mapping) via Toplink or EclipseLink.

You will see that REAL applications get to benefit from technology that typically lives in the world of Hibernate and Web Apps. You gotta love portable SQL database data persistance without building any tables or writing any SQL!

Speaker: Jon Batcheller

Jon is one of the founders of PJUG 13 years ago, who as a software engineer has been dabbling in code at places like Mentor Graphics and Synopsys, and now designs software for Vigilan in Wilsonville. In his massive spare time he is also a veterinarian, auctioneer, owner of Mock Crest Tavern, and teaches at PCC Sylvania.

PJUG meetings start with some time to eat and socialize (pizza and beverages are provided), followed by the featured speaker, then Q&A, discussion, sometimes a drawing to give away swag. :)

Though we like knowing how many people to expect, you don't have to RSVP, on Upcoming or otherwise. Go ahead and just show up!

Many people also go for a drink and further discussion following the meeting, at a location determined ad hoc (lately, the Market Street Pub at 10th and Market: http://mcmenamins.com/index.php?loc=24 ).

http://twitter.com/pjug http://pjug.org/ (join our mailing list, linked from the website!)

speaker: Robert Buels

Rob will give an introduction to and overview of DBIx::Class. It's an object-relational mapping framework, much better than the old Class::DBI, and it will make your life easier if you are currently writing a lot of SQL in your Perl.

As always, the meeting will be followed by social hour at the Lucky Lab.

Speaker: Hannah Stepanek

Let’s talk databases in python! What’s an ORM? Is there a way to write database queries so that they are compatible with multiple types of databases? How do you make database changes (such as adding a new table or a new column) safely? What is a connection pool and why is it useful? What are some things that can go wrong when operating at scale? In this talk we’ll take a deep dive into how the python libraries sqlalchemy and alembic make managing production databases simple, efficient, and painless so you can get back to feature development.

Hannah has been working in industry for over 6 years as a python software engineer. She currently works at Hypothesis, a web application for annotating web pages and pdfs. In her spare time she enjoys riding her horse Sophie and playing board games.

Open Sourcing DBIx::Class::Events

Andrew Hewus Fresh will be giving a trial run of his TPCiP talk

While I will explain a bit about what DBIx::Class::Events does and how it works, this talk is primarily about open source contributions being driven by the folks in a company who care about them and how it is up to those people to provide the resources and knowledge to everyone else in order to create an open source culture in the workplace. As far as I know, no request to open source something has ever been denied by my employer, Grant Street Group, and while the company has always had the same "go for it" attitude, the folks writing code are only just starting to gain momentum releasing things publicly. I'll talk about showing other folks in the company the benefits of sharing code internally, how that exposed the benefits of open-source in general, and how we as a company progressed to getting DBIx::Class::Events onto the CPAN.