July 23, 2018

Has anyone written a query on retention? Does anyone use this table or column? How do you use that function again? These are all questions you can answer using PopSQL's improved search capability, now available for Premium Team subscribers. You'll find a new search box in the top right of the app: Clicking the search box will open the search popup. You can also press Cmd+T for faster access. When the search popup opens, we'll show you recently opened queries so you can jump back somewhere if you need to.

Read More

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 <a href=”{{ getenv “APP_URL” }}/pricing">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