2
votes
Accepted
Best practice advice - store in DB or calculate on the fly (pset7)
Wow. Such a simple question with a complicated answer! The short answer is "it depends."
It depends on what your goals are. If processing time and resources don't matter, then it's whatever you want ...
1
vote
Accepted
pset7 finance insert new row
There is no ? in cs50x 2018 version of sql; ":bound :variables" are used to mitigate sql injection attacks.
Of the three "options" this db.execute("INSERT INTO users (username, hash) VALUES (:...
1
vote
Accepted
Set foreign key in phpLiteAdmin
If by this
recommended syntax for adding a column using SQLite does not appear to work.
you mean foreign key is not enforced, check out section 2 in SQLite doc, which says
Assuming the library is ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
database × 14pset7 × 6
python × 3
flask × 3
cs50x × 2
finance × 2
final-project × 2
sqlite × 2
pset6 × 1
html × 1
cs50-web-programming-with-python × 1
pset × 1
dna × 1
javascript × 1
index × 1
register × 1
jinja × 1
cs50w × 1
project1 × 1
phpmyadmin × 1
django × 1
login × 1
substrings × 1
postgresql × 1
flask-sqlalchemy × 1