SFPUG Special: JSONB Deep Dive

Peter Geoghegan, one of the major developers of the new "JSONB" binary, indexable JSON type for PostgreSQL 9.4, will be in town and will guide SFPUG members in a "deep dive" into the new technology, including:

• Both the new JSONB type and the old JSON type input and output JSON, so what's the difference?

• What new features does it offer?

• How is the new data type structured, and how does it work?

• How do you index JSONB?

• What things remain unimplemented?

Before the main event, we will have a Lightning Talk by Eric Ongerth: Running PostgreSQL in a Docker Container

Food and Drink, as well as Peter's travel, are sponsored by Heroku.  It is being hosted by SwitchFly.

Can't make it in person?  Join this Google Event to be in the Hangout which will start around 7:15PM.

Join or login to comment.

  • Peter G.

    Slides are now available from: https://speakerdeck.com/peterg/jsonb-deep-dive

    1 · June 25

  • Kati Giannini G.

    Great deep dive on the tech! Would like to have stayed for all of the present..Thanks for setting up.

    June 24

  • Peter G.

    The talk focused on aspects of the GIN indexing strategy that are used by the opclasses under the hood. I'm sorry that it seems to have gone over some people's heads. I did not mean to create an environment that was in any way exclusionary for its own sake. For what it's worth, I would have happily answered any questions that anyone might have had at any level. GIN indexing is really the most useful and compelling aspect of the new jsonb stuff, so it made sense to me to focus on it.

    When targeting a broad audience, it's difficult to pitch a talk at the right level technically. It's almost inevitable that some people will not fully get it, or some people will consider the material elementary. Hopefully among those that did not understand everything, most still got something out of it. I'd hoped that a big take away would be that jsonb_path_ops is very interesting. The small caveats must be considered, but it's worth it.

    Nikolay asked me to post slides. I'll do so later.

    5 · June 24

    • Randall L.

      I don't think there was a problem of it being too technical. If someone in the audience was making someone else feel like they couldn't ask questions, that is a problem. For me, the only issue was small text with low contrast.

      June 24

    • Josh B.

      Yeah, that's why I wish the complainer had hung around; I'd like to have gotten more specifics. As it is, I really can't do anything about anonymous complaints.

      June 24

  • Warren H.

    There was a really loud, pushy-sounding guy who created an unpleasant atmosphere. I didn't want to ask questions despite being confused because I didn't want to get confusing, condescending answers from him. The speaker doesn't seem to understand how to talk about Postgres to people who aren't Postgres experts: he started off with stuff I had never heard of and then it just got worse. He also stood directly in front of his slides (rather than, e.g., to the side of them) when they often contained information he was referencing (and not verbally repeating), so it became even harder to understand what was being presented.

    June 23

    • Josh B.

      Eric, it's a problem for me personally because I have no way to follow-up with the poster and get more information about this complaints.

      June 24

    • Eugene K.

      I'm sorry "former member" didn't enjoy it, but I found it very interesting and want to learn more; especially about vodka, the alternative to gin indexing. Wildcard prefix searching sounds like it might be useful.

      June 24

  • Nick H.

    Very good talk on a fairly advanced topic, but contained plenty of useful information for a relative novice such as myself. Also excellent pizza :-)

    June 24

  • Shashank

    I'm bummed I missed the talk. I'd love to see a recording and/or slides.

    June 24

    • Josh B.

      There will be a video up as soon as I edit it.

      June 24

  • Brian H.

    This was an advanced talk, aimed at PostgreSQL implementers. From that point of view, great stuff - rare to see in the open. (I did get a sinking feeling that attendees looking for a user-oriented talk would get lost, and in fact that was the case)

    2 · June 24

    • Randall L.

      The biggest barrier to understand was light yellow and brown tiny fonts on a white background.

      June 24

    • Josh B.

      Yeah, there were some slide design issues. It's a UG, not a conference, you roll with it.

      June 24

  • Nikolay S.

    Thank you Peter for your talk today, I learned some new useful things about new data type, that I didn't see in PGCon talks. Could you please publish your slides somewhere?

    June 24

  • Adam F.

    Nice to have a highly technical presentation.

    2 · June 23

  • Adam F.

    Any bike parking at the venue tonight?

    June 23

    • Josh B.

      FWIW, the meetup is in a good area of town, so if you bring a lock, leaving your bike outside shouldn't be an issue.

      June 23

    • Adam F.

      Great, garage or outside. Thanks!

      June 23

People in this
Meetup are also in:

Create a Meetup Group and meet new people

Get started Learn more
Henry

I decided to start Reno Motorcycle Riders Group because I wanted to be part of a group of people who enjoyed my passion... I was excited and nervous. Our group has grown by leaps and bounds. I never thought it would be this big.

Henry, started Reno Motorcycle Riders

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