Connecting to a SQLite Database Using Flask-SQLAlchemy

I'm done with MySQL! From now on, I'll be using SQLite instead unless I have a good reason not to. In this video I show you how to create a SQLite database and connect to it using Flask-SQLAlchemy.

[simba]

6 years later and this video is still relevant. Phenomenal !!!

[diahrongrismore]

The other nice thing about SQlite3 is, you can add a plug-in to your 'Firefox', 'Google-Chrome' and a couple of others. It's called 'SQLite Manager! With it installed into your browser, you do not have to install SQLite on your system. It has all the features you will need installed in your browser. You can open it, close your browser and use it and then shut it down, no overhead and easy to use.

[ferooyahya]

I just wonder, I'm using PyCharm on mac(I'm sorry i read the comments i know you are not much with it!) and trying to download sqlite3 but, all the sequel writing will be from the terminal? i cannot create .sql file like in mysql and manipulate it as i wish? thanks for the vid!!

[samiulhuda]

Thanks for the tutorial. Is it possible to host any flask project with SQLite in shared hosting/ Cpanel hosting. Could you make some tutorial for that?

[theGreatDpunisher]

thats odd I can import my database into my project but it wont create tables... theres no error or something..

[alanalmeida]

Can't we move the db.create_all() in the code instead of explicitly executing it in the python shell?

[gurucode.studio]

Dude, what would you really recommend to use, MySQL, Sqlite3 or Postgrsql ?, its really worth to know which of them is the best !, and thanks as always, it was a good tutorial :) .

[RenanL.S.]

I got an error: Either 'SQLALCHEMY_DATABASE_URI' or 'SQLALCHEMY_BINDS' must be set.

What is it?

[histavista]

Hey how can i use 1 sqlite db with 2 different flask web app

[salmonorigami]

I'm using OS X and Anaconda (Python 2.7.7) and am having trouble with "from main import db". It says there's no module named "main". Any idea why this is happening?

[drolbifshavers]

Sweet vid, man. How to create a table in the terminal(mac)? And which is the most time efficient way?

[paulinekarlsson]

Hey, thanks for a nice and clear video. I followed step by step and thought it'd work since it's so minimaltistic, but get this error when trying to run db.create_all():
Can't load plugin: sqlalchemy.dialects:sqlite3

Any ideas..?

[mishacol]

>>>from main import db
Traceback:
'ModuleNotFoundError: No module named 'main'


couldn't find solution to this one( any idea?

[mitchellpottratz]

What path do I use for = ? if I am using an online IDE like Cloud9?

[elinrossander]

How do I see my path? Yours started with "mnt" I don't really understand mine. I know this is the stupidest question, but where can I find it?

[ashishmaurya]

i m using pycharm and i m getting sqlite3 operational error while inserting value using html form


i don't know why ?
please help me with this...

[amanimasila]

hello where exactly is this file found?

[jaynepal]

I am getting this error

(sqlite3.OperationalError) unable to open database file

[prognoschool]

How should I create the DATABASE_URI path if my "database.db" is in this directory:

= 'sqlite://// ¿¿¿??? '

I'm on Windows10.

Help! :)

[ISLAMICchannel-frlz]

Hi I get this error:
Sqlitecompileerror:can't generate DDL for NullType(), did you forgot to specify the type of column