Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
11 views

Final Project ajax issue

Hi I'm working on my final project, an online two player game based on the cs5o Finace distribution code, I got tic-tac-toe to work and am now trying to update the playing field displayed to the user ...
0
votes
1answer
18 views

RuntimeError: missing value for placeholder (:name)

all! I'm doing the final project, and I have a form whose contents I'm trying to submit to a database. My python code is: @app.route("/Contact.html", methods=["GET", "POST"]) def Contact(): if ...
0
votes
0answers
78 views

DNA is good for the small database but not for the large database - CS50 Pset6

I'm currently developing the small and the large database functions separately and I wonder why in the large one it does not keep track of the STR repetitions. Here is my code from both functions: ...
0
votes
1answer
37 views

postgresql syntax error

So this is part of the import.py code in project1: db.execute("INSERT INTO books (isbn, title, author, year) VALUES (:isbn, :title, :author, :year)", {"isbn": isbn, "title": title,...
0
votes
2answers
28 views

CS50W Project1: ISBN too short, csv file does not provide correct ISBNs?

I was having an requests.exceptions.HTTPError: 404 Client Error: Not Found for url: error. I noticed after reading some of the documentation on Goodreads that we can use either 10-digit ISBNs or 13-...
0
votes
1answer
55 views

Finance register function does not insert data in database

I am trying to finish the register function but something goes wrong. I get an error message " It seems that although registration is claimed to be ok (from check50) nothing is actually added in the ...
0
votes
2answers
323 views

Can't Connect Python Flask With PSQL Database

every time i try to make connection between python and PSQL this error disappear ?
0
votes
1answer
17 views

Best practice advice - store in DB or calculate on the fly (pset7)

I have a table which is basically a "flat" list of all the purchase transactions done in the system - no aggregation of any sort. I was wondering if there are any best practices or guidelines as to ...
0
votes
1answer
86 views

pset7 finance insert new row

I'm trying to add a row into my finance db using the code below (a few versions), but keeping getting an error saying I'm passing in too many variables to the execute() function. Any direction here ...
0
votes
2answers
123 views

pset 7 [buy] Unable to render user's cash

I've spent a lot of time trying to solve this problem and can't seem to find were I went wrong. Any help is greatly appreciated. I am unable to render the user's cash balance on the index. def ...
1
vote
2answers
554 views

Password for phpLiteAdmin

I am requested to enter a password for phpLiteAdmin. I was following steps from the lecture, intro to phpliteadmin. After I inserted a new row ("name", "dorm") into the table registrants, I got this ...
1
vote
2answers
1k views

Set foreign key in phpLiteAdmin

Does anyone know how to set a foreign key using the phpLiteAdmin interface? The docs for this application are lacking, and the recommended syntax for adding a column using SQLite does not appear to ...
0
votes
0answers
37 views

Ruby Database Question Final Project

I'm working on my CS50 final project. The goal is a powerful webscraper using Nokogiri and Ruby that will pull event data from many sources on a weekly basis and then output that data as a CSV and ...