Better Autocomplete and Auto Limit

Better autocomplete, auto limiting results, and some performance improvements are all new in version 0.6.6 of PopSQL.

Better autocomplete

​Now suggestions will be more contextual. We’ll suggest columns for tables that are in your query. Works with aliases too!

GIF of autocompleting an inner join

Auto limit

​Sometimes you might forget to include a limit clause in your query and end up executing an expensive query. Now PopSQL will automatically include a limit 100 clause for you. Of course you can disable this whenever you want by unchecking the box, or providing your own limit clause.

Screenshot of auto limit feature

Performance improvements and bug fixes

Integer sorting is actually works now, and opening or closing Explore doesn’t take ages anymore. Enjoy!