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 ...
user avatar
  • 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 (:...
user avatar
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 ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible