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 ...
- 63.5k
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 (:...
- 26.8k
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 ...
- 26.8k
Only top scored, non community-wiki answers of a minimum length are eligible