Web App Database Setup

Question

Firstly, I have searched Yahoo and haven't found a good answer.

All the Flask SQLAlchemy tutorials use SQLite, but from what I read SQLite isn't really good with Heroku - or at least a Yahoo search of SQLite Heroku - reveals many issues with it?

If there aren't in fact any issues with using SQLite, please let me know.

How do I set a database up with Postgres and FlaskSQLAlchemy - since from my research that is what Heroku supports?

codegeek · Accepted Answer · 2012-12-06 20:01:51Z

1

Using Flask-SQLAlchemy, you can just do this:

from flask import Flask
from flask.ext.sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://username:password@host/dbname'
db = SQLAlchemy(app)

Now you can use this db object to do whatever you need.

Read here for more: http://packages.python.org/Flask-SQLAlchemy/config.html#configuration-keys

answered Dec 6, 2012 at 20:01

codegeek

33.5k12 gold badges65 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Web App Database Setup

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related