OpenSQL Camp is an un-conference style get together for people interested in Open Source Databases. We are not focusing on any one project, and hope to see representatives from a variety of open source database projects attend. OpenSQL Camp is free and our target audience are users and developers, but others are encouraged to attend too. See the website to sign up, and to see the full schedule.

The Portland PostgreSQL Users Group (PDXPUG)

John Naylor will be talking about his experience in Florida as a data manager for President Obama's 2008 campaign. He will discuss the role of data in political campaigns, and also refactor some data warehouse queries. Donuts and bacon provided.

Refreshments will be partaken at the Lucky Labrador Pub in SE Portland afterward.

Join the Portland PostgreSQL Users' Group for our monthly meeting!

When: 7pm Thursday, May 20 Where: FreeGeek Who: Mark & gabrielle What: What's new in 9.0

Drinks afterward at the SE Lucky Lab.

This month's topic is "Data Visualization and Exploration Techniques Using R and Postgres" with PSU's Dr Christopher Monsere.

Full details: http://pugs.postgresql.org/node/1669

Coming to OSCON? Be sure to come a day early and join us for another PgDay! This summer marks PDXPUG's 5th anniversary, and we want to see your smiling face! We will be celebrating at Gotham Tavern after the day of sessions. Sign up for sessions and afterparty here: http://bit.ly/f1F2Mz .

Yes, it's ok to show up just for the afternoon (or the party) if your flight arrives on Sunday.

We'd like a $30 donation to SPI for the sessions, but don't let lack of funds deter you from attending.

Developers, mobile app builders, NoSQL enthusiasts - join Orchestrate.io for discussions about databases, sharing war stories from production, and to have a little fun.

Please sign up here.

The meetup takes place at Ceili Ballroom at Kells Irish Restaurant on Wednesday, October 16, 2013. Led by Antony Falco, CEO of Orchestrate.io, and Adam DuVander, Developer Communications Director at SendGrid, we'll reflect on the life of infrastructure and databases as we once knew them, and raise our glasses to a future without them.

Libations and appetizers will be provided, with Interment to follow.

Topic: Synchronous Replication with MySQL

Summary: (TBD)

Speaker: Kenny Gryp

Kenny is currently Principal Architect at Percona. Bitten somewhere in the late 90s by the open-source bug, most of his spare time was spent working with Linux & OpenBSD servers.

Before joining Percona, he worked at a large social networking company in Europe as DBA & Puppeteer.

Schedule:

6:00 beer, soda, pizza

6:15 presentation

7:15 chat

7:30 end

There will be pizza, so please register on meetup.com so that we can order the proper amount.

Who: Josh Berkus
What: What's new in PostgreSQL 9.5
Where: PSU, 1930 SW 4th Ave. Room FAB 86-01 (Lower Level)
When: Thursday, April 7th, 2016 at 7pm
Why: The pursuit of technology freedom
Stream: http://pdxlinux.org/live (PSU WiFi Permitting)

PostgreSQL 9.5 has many new and cool features for database users, making the venerable RDBMS suitable for even more workloads. Among them are:

• UPSERT for high-concurrency insert/update operations
• Row Level Security, integrated with SELinux, for ultimate data security
• CUBE and ROLLUP for sophisticated analytics
• FDW partitioning for data federation
• BRIN indexes for big data
• More JSON goodness

PostgreSQL Core Team member Josh Berkus will take you on a tour of the new features, including demos of many of them, and field questions about PostgreSQL in general.

About Josh

Josh Berkus is on the Core Team of the PostgreSQL Project, and was a professional database geek for 18 years. Today, he works for Red Hat as the community lead for Project Atomic, which means he's all about the containers. He has used a Linux desktop since 2001.

Rideshares Available

PLUG Page with information about all PLUG events: http://pdxlinux.org/ Follow PLUG on Twitter: http://twitter.com/pdxlinux

PLUG is open to everyone and does not tolerate abusive behavior on its mailing lists or at its meetings.

RSVP Required see RSVP instructions below!

May is all about SERVICES! Particularly, Service Meshes and the Open Service Broker.

First Talk: An introduction to Conduit, the Rust-based service mesh for Kubernetes

The creators of the CNCF-hosted Linkerd service mesh, Buoyant, recently introduced Conduit--a new, ultralight service mesh made explicitly for Kubernetes. In this talk, Buoyant engineer Carl Lerche will introduce you to Conduit, its design philosophy, how it’s used to add reliability, security, and visibility to Kubernetes applications, our motivations for writing the Conduit data plane in Rust, and how to get involved.

Second Talk: Stateful is Hard: Hooking Apps up to Managed DBs

Kubernetes lets us write crazy-powerful apps these days, and all three clouds will host it for you in some shape or form now. The result is that our apps are mostly portable, but there's more work to do in this space. Aaron Schlesinger of the Microsoft Azure Containers group explains.

Databases are hard to maintain if you run them in Kubernetes. Same with pub/sub systems, or any combination of stateful and data really. Sometimes we just want to hook our apps up to the cloud equivalents of these things, so we don't have to manage them. How do we do that in a portable way? Enter the Open Service Broker (OSB) API and Kubernetes Service Catalog.

Learn how to connect your apps to all your favorite cloud services without ever opening the portal or using the CLI. It's the same OSB API for all the clouds, and the same Kubernetes Service Catalog resources for any cluster. We're getting to a place where you can get the services you need without caring what cloud your app runs on.

RSVP Required for this venue. Either RSVP via Meetup.com (preferred), or send email to josh(at)berkus(dot)org with your full name that matches your ID. All RSVPs must be received by 4pm May 16th.

For an opening act, CNPDX organizer Josh Berkus will demo a walk-through of deploying high availability PostgreSQL as an application on Kubernetes.

Our main event will be:

Deploying TiDB, a distributed open-source MySQL-Compatible HTAP Database, using Kubernetes

This talk will introduce TiDB's architecture, key use cases, a user story with Mobike (one of the largest bikesharing platforms in the world), and a deep-dive into deploying TiDB as a stateful application using Kubernetes. TiDB is built by the company PingCAP and its open-source community.

Speakers: Ed Huang (co-founder/CTO of PingCAP), Kevin Xu (GM of U.S. at PingCAP)

As a special bonus for this meetup, TiDB will hold a business card raffle for a Google Home Mini at the end of the presentation.

Our meetup host this month will be software maker Eleven.

PLEASE RSVP on Meetup.com if you can, so that we can get a headcount for food.

The Portland Java User Group is holding a meeting on Tuesday January 22nd at Oracle Portland (1211 SW 5th Ave #800 · Portland, OR). This meeting will have two speakers: 1) Ian Downard will give a short talk about a new OpenJDK distribution from Amazon called Corretto. 2) Chris Anderson from FaunaDB will talk about the principles of serverless databases and tradeoffs in guaranteed consistency and global replication.

Please RSVP here: https://www.meetup.com/PDXJUG/events/258141081/

Hope to see you there!

Consistency, Durability, Scalability, and Availability and your data stores: a review of various distributed database topologies, and a discussion of what problems they are best suited to solve.

Today's admin and SRE teams may find themselves afloat in a sea of acronyms and carefully worded promises when they consider how to scale their database layer without sacrificing critical uptime and consistency guarantees.

Developed to provide a North Star for our own teams when they look at scaling any particular workflow, come listen to our presentation 'On The Kinds of Uptime Worth Wanting'. Robust discussion and refreshments to follow.

Pizza and Refreshments will be provided.

https://www.freecodecamp.org/ is a great online resource for learning how to code. It gives you step by step challenges with example lessons to code. There are even hints and video tutorials if you get stuck.

The only missing component is how to share your achievements with friends and get inspired by others. That's where Knowledge Mavens can help. Join us to stay motivated to complete the boot camp. We're holding a two-hour workshop to work on challenges and share our progress.

If you haven't tried Free Code Camp. I can help you get started. Be sure to bring your laptop so we can code together.

Be inspired! Knowledge Mavens

PostgreSQL 15 was released on October 13, 2022 so let's give it a look!

We will shamelessly use a presentation readily available on the internet to see all the newness in this latest release.

Come learn what's new, share experiences with changes, or just meet with local peers! Casual, informal.

Keith Belanger, SqlDBM Product Evangelist

Keith Belanger has over 27 years experience in the Data Architecture space and started his journey as a Data Modeler in the OLTP space and eventually migrated over to the OLAP space. He has had many roles over the years including ETL Development, BI Administration, DBA & Data Architecture. He was the Senior Data Architect and Director of Data Architecture for a Fortune 100 P&C Insurance Company. He also has consulted many companies in many verticals on their Data Modernization strategies. Keith is expert in Kimball (Star Schema) & Data Vault 2.0 solution strategies. Recognized Snowflake Data Superhero and board member of the Data Vault North America User Group.

Abstract In this presentation we will explore the benefits of top-down modeling approaches and emphasize the value of top-down modeling in data warehousing and highlight the importance of ontologies. We will discuss "why" top-down models should be considered, "how" to develop these models and apply it to your data warehousing initiatives. Ultimately, encouraging the adoption of top-down modeling as a flexible and forward-looking approach that can better meet the evolving needs of businesses while delivering tangible value.

RSVP for Google Meet link to be sent in advance, and available on the Eventbrite Online Event Page.

Streamline your app development with a local-first database.
In this workshop we'll build a React app together, implementing basic data models in Fireproof, with automatic sync across devices using PartyKit. Once the basics are in place, we can explore using Fireproof in specific use cases, whether it's encrypted content management or offline inventory controls. We have a handful of starter kits you can use to fast-forward to working LLM chatbots, content editors, file uploads, etc.

Workshop participants should be familiar with Node.js and NPM or Yarn, React, and Git. We'll be working in VS Code but you can use whatever editor you prefer.

RSVP on Meetup.com
Space is limited, RSVP early and remember to bring your laptop!

-=== Schedule ===-
5:40-6:00 pm - Arrivals
6:00 - 7:00pm - Workshop ReactJs + Fireproof
7:00 - 8:00pm - Social hour & Networking

-======-
If you are new to the group, welcome! We hope that you find this community a friendly and open one. Join 2000+ other members in our Slack channel https://pdxreact.com.
To new and existing members, please take a look at the code of conduct for our group.
-======-