Typically with a WHERE clause, you use IS to specify the conditions. We want to pull the records WHERE the field deleted_at IS NULL. The WHERE clause lets us pull just the email address and id from specific rows (or records) that match our conditions. Now we’re introducing a new element, the WHERE. SELECT(id, email_address) FROM users WHERE deleted_at IS NULL In this case, we’re pulling the id and email_address FROM the users table. This tells your database which table we want to pull the fields from. Note: use * to pull every field in the row. If your database has a field email-address and you write SELECT (email_address) the query won’t work. It’s important to write the names of the fields exactly the way they are setup in your database. In this case, we’re just pulling the email_address and id fields. The SELECT identifier tells the database what fields we want to pull. This query will pull a list of the ids and email addresses for every user in the users table of your database (every row in a relational database has some sort of unique id). Here are five SQL queries that will help you analyze your data, along with tips on why each one is useful and how they work. Now that you’ve got Postico all set up, it’s time to learn a little SQL. 5 SQL queries every non-technical founder should know TablePlus also says they’re working on a Windows version, so you may want to keep an eye on them.
SEE HOST IN POSTICO 64 BIT
You’ll want to download the file titled, “ pgweb_windows_” or “pgweb_windows_” if you’re on a 64 bit system (ask your nerdy nephew).
SEE HOST IN POSTICO FREE
It’s free to use and you can download it here: I’d recommend PGWeb because it actually looks like it was built in the 21st century. They’ll be pretty similar, but a little more complicated to get setup. If you’re on Windows, there are a couple of good alternatives you can check out. This means you’re constantly having to tweak what you’re tracking (which you should do).Īnd that’s it! You’re now in your database and running queries.Īs I mentioned above, Postico is a Mac app. And when you’re first getting your product off the ground you’re making changes constantly. Often, you don’t know exactly what you need to track until you have a critical mass of active users. Analytics tools only work as well as you tell to And the sooner you set it up, the more data you’ll have to work with.īut there are two ways this stack falls short: 1. It’s cheap, relatively easy to set up, and can give you powerful insights. This setup works great for giving you an idea of where your traffic is coming from, and a high level view of your product usage.
SEE HOST IN POSTICO CODE
They get a little technical, but you can find everything you need for getting your base set up there (you won’t need to be a full-fledged programmer to set these up, but you will need to be able to copy and paste some code without getting overwhelmed).Īnd Moz, the industry leader on SEO, has an awesome guide to the basics of Google Analytics.
If you’re more the DIY type, you can dig through Segment’s documentation and the Mixpanel docs.
0 kommentar(er)
