The aim of this guide is to walk you through launching our basic flask-base repository found here and will also cover some common situations and issues encountered from previous projects.
Gobble Til You Wobble 1M 5K 10K 13.1 26.2 - Save $5! Virtual Run Events. October 16 - 17, 2021. 5 to 10 for a Georgia Nurse! Virtual Fundraising Race. If my memory serves right, Eager Apps, one-man company behind Postico, makes around $10K / month selling a Mac App for Postgres administration. I think being entrepreneur is vastly more fruitful and less stressful with small stepping stones and for a start, it's a better to sell small things on side then dive into growing the $10K Month SaaS. EDGELEC 100pcs 10K ohm Resistor 1/2w (0.5Watt) ±1% Tolerance Metal Film Fixed Resistor, Multiple Values of Resistance Optional. 4.7 out of 5 stars. 99 ($0.60/10 Items) Get it as soon as Wed, Jun 30. FREE Shipping on orders over $25 shipped by Amazon. Limited Warranty (years) 5 5 5 5 5 5 1 One gigabyte, or GB, equals one billion bytes and one terabyte, or TB, equals one trillion bytes when referring to drive capacity. 2 Seagate Secure drives and FIPS 140-2 Validated drives are not available in all models or countries. Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike. Postico will look familiar to anyone who has used a Mac before. Just connect to a database and begin working with tables and views. Start with the basics and learn about advanced features of PostgreSQL as you go along.
What is Heroku and Why are we using it?
To get started we are going to cover what heroku is and how to set it up.
Just a little bit of background. Currently, when you run your app with python manage.py runserver or foreman start -f Local you are running on your computer only (on something like localhost:5000). Of course this means that if anyone tries to access your application, they will be stuck with a 404 not found error. Thus we must put your application onto a publicly accessible computer that is constantly running. This is exactly what a server does. When you type in something like hack4impact.org, a request is first sent to a Domain Name Server or DNS which then maps the domain name hack4impact.org to an IP Address which points to the server which then renders pages and serves them over to you, the client. Seems simple. But how do you get a server?
Heroku is the answer. The heroku platform is a cloud platform that runs your apps in containers called dynos and hosts these apps for free (..ish, we'll get to pricing later). These dynos can host apps and allow you to scale the applications infinitely (at a cost of course) to handle more traffic. Additionally, the heroku dynos contain all the code you need to run a python app from the get go and will install any pip dependencies. Your app lives in a remote git repository on heroku's servers. When you push to the remote heroku repository, heroku will merge the changes, reset your server, and run the new version of your app. Heroku makes this entire process seamless, so its super easy to maintain your app well after it has been launched.
Now that we have a good understanding of what heroku is and why we want to use it. Let's get started with launching the application to heroku!
Basic Setup: Heroku Account and CLI Installation
Head over to https://signup.heroku.com to set up an account. Once you are set up, confirm your email and set up your password.
Next, install the heroku command line interface (CLI) for your operating system at https://devcenter.heroku.com/articles/heroku-cli.
Heroku Dyno Creation and Initial Setup
Go to the directory containing the application you wish to launch. For demo purposes, we will be using the flask-base repository which you can clone from https://www.github.com/hack4impact/flask-base. This is a python application that has a SQLite database and a Redis Task Queue.
Go to your terminal and type in heroku login. If you have set up everything correctly with the CLI installation in the previous section, you should be prompted for your Heroku account credentials (from the previous section as well).
Before creating a heroku dyno, make sure you are at the root directory of your application. Next make sure your application is a git repository (you can do git init to make it one), and make sure the current git branch you are on is master since heroku only pushes changes from that branch. Also make sure that your requirements.txt file contains all the pip modules to work (you can do pip freeze > requirements.txt to place all your installed pip modules in requirements.txt).
To create the dyno, run in the terminal heroku create .
Note that I use to indicate that the variable is optional and the carats should be excluded. E.g. a valid interpretation of the above would be heroku create or heroku create myappname but NOT heroku create .
Heroku will create an empty dyno with name you specified with app-name or a random name which it will output to the terminal.
Your application will be accessible at https://flask-base-demo.herokuapp.com (per the example above) and the remote github repository you push your code to is at https://git.heroku.com/flask-base-demo.git.
Next we can run git push heroku master. This will push all your existing code to the heroku repository. Additionally, heroku will run commands found in your Procfile which has the following contents:
This specifies that there is will be a web dyno (a server that serves pages to clients) and a worker dyno (in the case of flask-base, a server that handles methods equeued to the Redis task queue).
Softorino youtube converter 2 1 2. If all goes well, you should see an output something similar to this:
Configuration
Next we have to set up some configuration variables to ensure that the application will be in production mode.
From the command line run
Also set your Sendgrid email credentials as configuration variables as well (if you want the application to send email)
Next you should add a SECRET_KEY
And also set, SSL_DISABLE to False
If you plan to use redis, go to https://elements.heroku.com/addons/redistogo?app=flask-base-demo and follow the onscreen steps to provision a redis instance.
Also if you have a Raygun API Key, add the config variable RAYGUN_APIKEY in a similar fashion to above. This will enable error reporting.
Database Creation & Launching
First run heroku ps:scale web=1 worker=1. You may need to add a credit card for this to work (it will notify you on the command line to do that).
Next run heroku run python manage.py recreate_db to create your database.
Lastly, run the command to add an admin user for you app. In flask base it will be the following heroku run python manage.py setup_dev.
In general if you want to run a command on the app it will be in the format of heroku run . Additionally you can access the file system with heroku run bash.
You can now access your app at the URL from earlier and log in with the default user.
Domain Name + HTTPS Setup
This guide encompasses all you need to get set up with SSL https://support.cloudflare.com/hc/en-us/articles/205893698-Configure-CloudFlare-and-Heroku-over-HTTPS.
Debugging
heroku logs --tail will open up a running log of anything that happens on your heroku dyno.
Additionally, if you have Raygun configured, you'll get error reports (otherwise, you can look at older versions of flask base where we sent errors to the main administrator email).
1-5 10k Means
Lastly, you can use an application like Postico to actually look at your database in production. To get the credentials for the application to work with Postico, do the following:
Run
heroku configto print out all configuration variables.Find the
DATABASE_URLvariable, it should look something likepostgres://blahblahblah:morerandomstuff123456@ec2-12-345-678-9.compute-1.amazonaws.com:5432/foobarIn Postico, click 'New Favorite'.
For the fields use the following reference to interpret the parts of the
DATABASE_URLvariable:postgres://User:Password@Host:Port/DatabaseIf you want to view your redis queue, use the following web interface https://www.redsmin.com/ or the command line.
Heroku considerations, scaling and pricing
If your application uses file uploads, Heroku does not have a persistent file system, thus you need to set up a Amazon S3 Bucket to upload your file to. This heroku guide has a nice way to upload files with AJAX on the frontend https://devcenter.heroku.com/articles/s3. You can also view the Reading Terminal Market Repo for an example of how to use file uploads
Heroku has a limit of 30 seconds on processing a request. This means that once a user submits a request to a URL Endpoint, a response must be sent back in 30 seconds, otherwise the request will abort and the user will get a timeout error. You should explore using a Redis queue to process requests in the background if they require more than a few seconds to run. Or you can issue AJAX requests on the frontend to a URL (at least this will just silently fail).
Heroku postgresQL has a limit of about 10k rows. If your application will use more than that, then you should follow this guide.
Also you should upgrade your heroku instance to the hobby tier to ensure that it will be working 24 hrs. The free tier will only work 18 hrs a day and will sleep the application after 5 minutes if inactive (meaning that it will take a while to start up again from a sleep state). You can change this on the heroku dashboard https://dashboard.heroku.com/apps/.
Postico 2 is a database app with a very strong focus on its core audience: people who use databases. Our customers range from researchers and analysts to app developers and students. Whether you want to enter data, search data, or perform SQL queries, Postico has you covered.
Postico 2 is the next major version coming after Postico 1.5. If you'd like to know more about Postico 1.5, click here.
The new SQL query editor makes working with a lot of queries easier than ever:
- Create multiple SQL files and organize them into folders
- Open the same file in multiple tabs or windows
- Postico autosaves changes so you never lose your work
- Drag any SQL file into the sidebar to add it to Postico
- Edit SQL files with other text editors like VS Code, Atom, Sublime, Textmate, …
- Auto-format SQL queries with Ctrl-F: pgFormatter is now built in!
Click a table in the sidebar, and see the data instantly. Add rows, edit them, or filter them. Powerful features like the foreign key picker or the row detail sidebar make editing all kinds of tables a breeze.
Postico has a powerful graphical structure editor for creating and altering tables. Add a column, edit data types, set a default value. Columns, indexes and constraints are unified in a single editor, so you see everything at once.
And the more technically inclined can view the structure as raw SQL (DDL view).
You can now edit functions and stored procedures.
Postico can now update silently in the background. We know that you have more important things on your mind than dealing with software updates. So unless you disable automatic updates, Postico will never interrupt you with an update notification again.
This allows us to release updates to Postico more frequently than ever before. Every new feature, every refactor, and every bugfix is built and automatically published by our new build system (see the changelog).
The streamlined interface means that your servers are never more than two clicks away. Connection management in Postico 2 has been optimized for everyone, whether you use a single server, or hundreds of them:
To create the dyno, run in the terminal heroku create .
Note that I use to indicate that the variable is optional and the carats should be excluded. E.g. a valid interpretation of the above would be heroku create or heroku create myappname but NOT heroku create .
Heroku will create an empty dyno with name you specified with app-name or a random name which it will output to the terminal.
Your application will be accessible at https://flask-base-demo.herokuapp.com (per the example above) and the remote github repository you push your code to is at https://git.heroku.com/flask-base-demo.git.
Next we can run git push heroku master. This will push all your existing code to the heroku repository. Additionally, heroku will run commands found in your Procfile which has the following contents:
This specifies that there is will be a web dyno (a server that serves pages to clients) and a worker dyno (in the case of flask-base, a server that handles methods equeued to the Redis task queue).
Softorino youtube converter 2 1 2. If all goes well, you should see an output something similar to this:
Configuration
Next we have to set up some configuration variables to ensure that the application will be in production mode.
From the command line run
Also set your Sendgrid email credentials as configuration variables as well (if you want the application to send email)
Next you should add a SECRET_KEY
And also set, SSL_DISABLE to False
If you plan to use redis, go to https://elements.heroku.com/addons/redistogo?app=flask-base-demo and follow the onscreen steps to provision a redis instance.
Also if you have a Raygun API Key, add the config variable RAYGUN_APIKEY in a similar fashion to above. This will enable error reporting.
Database Creation & Launching
First run heroku ps:scale web=1 worker=1. You may need to add a credit card for this to work (it will notify you on the command line to do that).
Next run heroku run python manage.py recreate_db to create your database.
Lastly, run the command to add an admin user for you app. In flask base it will be the following heroku run python manage.py setup_dev.
In general if you want to run a command on the app it will be in the format of heroku run . Additionally you can access the file system with heroku run bash.
You can now access your app at the URL from earlier and log in with the default user.
Domain Name + HTTPS Setup
This guide encompasses all you need to get set up with SSL https://support.cloudflare.com/hc/en-us/articles/205893698-Configure-CloudFlare-and-Heroku-over-HTTPS.
Debugging
heroku logs --tail will open up a running log of anything that happens on your heroku dyno.
Additionally, if you have Raygun configured, you'll get error reports (otherwise, you can look at older versions of flask base where we sent errors to the main administrator email).
1-5 10k Means
Lastly, you can use an application like Postico to actually look at your database in production. To get the credentials for the application to work with Postico, do the following:
Run
heroku configto print out all configuration variables.Find the
DATABASE_URLvariable, it should look something likepostgres://blahblahblah:morerandomstuff123456@ec2-12-345-678-9.compute-1.amazonaws.com:5432/foobarIn Postico, click 'New Favorite'.
For the fields use the following reference to interpret the parts of the
DATABASE_URLvariable:postgres://User:Password@Host:Port/DatabaseIf you want to view your redis queue, use the following web interface https://www.redsmin.com/ or the command line.
Heroku considerations, scaling and pricing
If your application uses file uploads, Heroku does not have a persistent file system, thus you need to set up a Amazon S3 Bucket to upload your file to. This heroku guide has a nice way to upload files with AJAX on the frontend https://devcenter.heroku.com/articles/s3. You can also view the Reading Terminal Market Repo for an example of how to use file uploads
Heroku has a limit of 30 seconds on processing a request. This means that once a user submits a request to a URL Endpoint, a response must be sent back in 30 seconds, otherwise the request will abort and the user will get a timeout error. You should explore using a Redis queue to process requests in the background if they require more than a few seconds to run. Or you can issue AJAX requests on the frontend to a URL (at least this will just silently fail).
Heroku postgresQL has a limit of about 10k rows. If your application will use more than that, then you should follow this guide.
Also you should upgrade your heroku instance to the hobby tier to ensure that it will be working 24 hrs. The free tier will only work 18 hrs a day and will sleep the application after 5 minutes if inactive (meaning that it will take a while to start up again from a sleep state). You can change this on the heroku dashboard https://dashboard.heroku.com/apps/.
Postico 2 is a database app with a very strong focus on its core audience: people who use databases. Our customers range from researchers and analysts to app developers and students. Whether you want to enter data, search data, or perform SQL queries, Postico has you covered.
Postico 2 is the next major version coming after Postico 1.5. If you'd like to know more about Postico 1.5, click here.
The new SQL query editor makes working with a lot of queries easier than ever:
- Create multiple SQL files and organize them into folders
- Open the same file in multiple tabs or windows
- Postico autosaves changes so you never lose your work
- Drag any SQL file into the sidebar to add it to Postico
- Edit SQL files with other text editors like VS Code, Atom, Sublime, Textmate, …
- Auto-format SQL queries with Ctrl-F: pgFormatter is now built in!
Click a table in the sidebar, and see the data instantly. Add rows, edit them, or filter them. Powerful features like the foreign key picker or the row detail sidebar make editing all kinds of tables a breeze.
Postico has a powerful graphical structure editor for creating and altering tables. Add a column, edit data types, set a default value. Columns, indexes and constraints are unified in a single editor, so you see everything at once.
And the more technically inclined can view the structure as raw SQL (DDL view).
You can now edit functions and stored procedures.
Postico can now update silently in the background. We know that you have more important things on your mind than dealing with software updates. So unless you disable automatic updates, Postico will never interrupt you with an update notification again.
This allows us to release updates to Postico more frequently than ever before. Every new feature, every refactor, and every bugfix is built and automatically published by our new build system (see the changelog).
The streamlined interface means that your servers are never more than two clicks away. Connection management in Postico 2 has been optimized for everyone, whether you use a single server, or hundreds of them:
- Filter servers
- Organize servers into nested groups
- Support for syncing server settings with iCloud or Drop Box
- Startup Queries allow customising server settings (eg. read-only connections)
Postico tries to support all PostgreSQL-compatible databases. In addition to PostgreSQL, we have first class support for Amazon Redshift, Greenplum, and CockroachDB.
Some databases like Vertica are supported only in a limited way: executing SQL is possible, but other features do not work.
Postico now has a dedicated 'Feedback' button in the toolbar to send feedback or to request support. Postico will include relevant version numbers automatically, and optionally even include a screenshot of the current window. You can send feedback anonymously, or you can include your email address if you want us to get back to you.
Alternatively, you can continue to contact us via email (postico@eggerapps.at) or via our Github Issues page.
Postico 1 5 10k
- Preview builds expire after 6 weeks. Postico 2 updates itself, so unless you disable automatic updates that should not be an issue.
- Postico 2 Preview has limits similar to the free trial of Postico 1.5 and needs to be activated to unlock all features (eg. multiple tabs). You can activate Postico 2 Preview either with a Postico 1.x license, or you can buy a license for Postico 2.
We have been using Postico 2 ourselves for more than a year, and we are not aware of any critical bugs. We still recommend to follow best practices and to always have a backup of your data.
- Email us: support@eggerapps.at
