SFRails - LT | NoSQL in SQL: Have It All | LT | Working w/ Time Series Data

Agenda 

6:30 Food/Beer/Networking 
7:00 Intros/Sharing of Tips and Tools 

7:15  Talks  

  •  Lightning Talk :  Alyssa Ravasio
  •  Talk 1: NoSQL in SQL: Getting to Have It All - Andrew Geweke
  •  Lightning Talk :  Lucas Dohmen 
  •  Talk 2: Working with Time Series Data - Paul Mestemaker

8:30 End


Lightning Talk : Hacking Webforms with Phantom.JS!

About the Speaker

Alyssa Ravasio is the founder and CEO of Hipcamp.com, a startup that helps you discover and book epic campsites. She is a graduate of Dev Bootcamp and also has a degree from UCLA in Digital Democracy. Her deepest passion is helping shape how the internet changes our humanity and our planet. 

Talk 1: NoSQL in SQL: Getting to Have It All

The last few years have seen an explosion of interest in NoSQL data-storage layers, and then some retrenchment as the limitations of these systems became increasingly apparent. (It turns out they’re not magic, after all!) Today we seem faced with a choice. On one hand, we can reach for some of the potential “big wins” of NoSQL systems, but many of them are still relatively immature — at least when compared to the RDBMS — and the things we give up (transactionality, durability, manageability) we often discover to be very painful losses. On the other hand, we can reach for the security of a traditional RDBMS; we get incredibly well-understood, robust, durable, manageable systems…but we often sacrifice a lot of potential future growth.

We’ll show you how to have some of your cake and eat some of it, too. We’ll introduce a combination of architectural patterns and software (including two brand-new RubyGems) that let you build schema-free, scalable data storage inside a traditional RDBMS, and show you how just changing your deployment options lets you scale the same codebase and database design from a site that’s just barely getting started to one under extremely high load. (These are the same techniques used by sites like Scribd, which happily serve dozens of pages per second from a RDBMS.) These techniques also open up an easy migration path for you to move appropriate data sets to a NoSQL system when desired, allowing you to form a “blended” system that gives you the best of both worlds.  

About the Speaker

Andrew Geweke has been building Rails code for over eight years, and has been a professional software engineer for 16. In the last few years he’s managed teams of engineers and technology platforms at Scribd and Couchsurfing, both very large Rails sites. Recently, he’s been working more on evangelizing the technology platforms he’s developed and communicating more to the broader Rails community.

Lightning Talk : Guacamole for ArangoDB

Guacamole is a Ruby ODM for the open source NoSQL database ArangoDB that uses the Data Mapper pattern.

About the Speaker

Lucas Dohmen is a member of the core team of the NoSQL database project ArangoDB where he works on the graph functionality, tools for the Ruby community to use the database, and Foxx. He contributes to various open source projects like hacken.in (an event calender for nerds in Cologne, Berlin and Munich) and projects related to ArangoDB.


Talk 2: Working with Time Series Data

Over the last few years, there has been incredible growth in the amount of sensors producing data as well as a sharp increase in frequency in which each sensor emits data. Temperature & pressure gauges, heart beat monitors, GPS devices, Fitbits, analytics platforms all produce time series data -- e.g. key: #{timestamp}, value: #{value}.  The sheer amount of data generated can be costly to store in its most granular form. So businesses often choose to aggregate and discard the raw data in order to reduce costs or to prevent scaling issues.  

The problem with that is that aggregating data is inherently lossy, so you could lose valuable insights. If you want to keep the raw data, you could store it in something simple like flat files, but then it is difficult to analyze.  If you store it in a relational database, you'll quickly run into performance and scaling issues.  One of the most common problems is that the more data you capture, the longer it will take to read that data out.

In this talk, Paul will give an overview of how to deal with loading, reading, and graphing large time series datasets using Ruby, JavaScript, D3.js, and TempoDB (a purpose-built time series database). 

About the Speaker

Paul Mestemaker is the founder of CleverPoint LLC, a technology consulting firm based in San Francisco. He and his team help companies and nonprofits accomplish their goals through clever applications of technology. Previously, Paul was a PM at Microsoft, co-authored a book on SQL Server Performance Tuning, and helped a couple of startups build their teams and launch their products.


About the Sponsor/Host 

The Climate Corporation helps people and businesses manage and adapt to weather events and climate change. The company’s unique technology platform enables the real-time pricing and purchasing of customizable weather risk management products using proprietary global weather simulation modeling and local weather monitoring systems.


Other Sponsors

Iron.io is the maker of IronMQ, a scalable cloud-based message queue, and IronWorker, an elastic task queue/worker service. Iron.io's services are designed for doing things asynchronously and operating at scale. (@getiron

Join or login to comment.

  • A former member
    A former member

    Hey, very happy to have hosted everyone tonight. I hope there was enough food/drink for everyone. Great talks, great turnout, lots of new faces. Please reach out to me or, better, [masked] if you have any recruiting questions.

    On a separate note..

    224 people RSVP'ed 'yes' to this event. Around half made it. This makes it very difficult to order food/drinks and plan for capacity.

    I've seen other meetups deal with this by capping attendance, having a waitlist, and asking people nicely if they could change their RSVP if they change their mind. I'd really love to see this start happening with SFRails.

    I'm leaving this here as a public comment, because if others agree/disagree, I'd like to know.

    SFRails is a big group, so shout out to all the organizers for making it one of the best run meetups I go to.

    2 · May 15

    • Andrew G.

      I don't know if it's technically feasible on the Meetup platform, but: send out confirmation request emails 1-2 days beforehand. Base your food/drinks purchase on some fraction (e.g., 130%? 150%?) of the number of people who confirm then. All we need is a roughly consistent linear proxy for the number of people who show up, and I bet that's a lot closer than basing it on the number of signups in the first place.

      1 · May 16

    • A former member
      A former member

      Yes, that's true. But capping RSVPs and enforcing a waitlist helps create a better base line to estimate the number of people that will show up.

      May 16

  • Andrew G.

    Thanks again to everybody who came out last night! It felt great to have this as a forum to express fun Rails ideas.

    Here's a (slightly extended) copy of my slides from last night: https://speakerdeck.com/ageweke/...­

    And here's the software I spoke about:

    https://github.com/ageweke/flex_...­
    https://github.com/ageweke/low_c...­
    https://github.com/kovyrin/db-ch...­

    You can find other software I've written at https://github.com/ageweke­. Feel free to reach out if any of it interests you! I'm @ageweke on Twitter and [masked].

    1 · May 16

  • Anthony S.

    Great speakers and topics! I look forward to the next meet up!

    May 16

  • Sylvie C.

    Very interesting

    May 15

  • A former member
    A former member

    My slides are up now :) If you have questions or feedback, ping me on Twitter (@moonbeamlabs) or send me an email (lucas _at_ ArangoDB.org).
    https://speakerdeck.com/moonglum...­

    May 15

  • Piyush G.

    All the speakers were really good

    1 · May 15

  • A former member
    A former member

    Hey, is the lightning talk slot available?

    May 12

    • Yaron S.

      No, sorry for the confusion. Updating now.

      May 12

Our Sponsors

  • Iron.io

    Organization @getiron

  • App Academy

    Organizational Help

  • Supporters and Past Hosts

    Location and Refreshments

  • pagerduty

    Food | Drink | Location

  • Blurb

    Location | Food | Drink

  • Fastly

    Food | Drink | Location

  • TeeSpring

    Location

  • Telmate

    Food | Drink

  • Autodesk

    Location | Food | Drink

  • Media & Community Partners

    Media Sponsorship | Community Outreach

People in this
Meetup are also in:

Imagine having a community behind you

Get started Learn more
Rafaël

We just grab a coffee and speak French. Some people have been coming every week for months... it creates a kind of warmth to the group.

Rafaël, started French Conversation Group

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