Dark Mode

May 23, 2018

If you’re writing code for hours, you want something easy on your eyes. That’s why we created dark mode for PopSQL, by popular demand. Dark mode is available today for Premium users. To turn it on, go to Preferences > Editor > Theme, or in your menubar, View > Dark Mode. Enjoy!

How to Export Raw Mixpanel Data to Your Database

February 23, 2018

Mixpanel is great, but it’s very helpful to have your raw event data in your database so you can use SQL to extract insights. In this post, I’ll show you how you can accomplish that. We’ll be using Ruby on Rails and PostgreSQL, but the general approach of pulling data from Mixpanel, inserting it into the database, and scheduling a background job on an interval should work with any language and database.

Read More