search

AscSecTeam / knackered

Scoring Engine API Service
MIT License
0 stars 0 forks source link

pick database solution #6

Closed brettlangdon closed 10 years ago

brettlangdon commented 10 years ago

where are we going to store the data?

my vote here is on sqlite https://docs.python.org/2/library/sqlite3.html, it is built into python standard library and is similar enough to mysql (or mssql) that it should be a big deal to implement.

we would need to setup config options for creating/accessing the db, would need to try and create the tables that are needed and everything on boot and also start thinking about the structure of the tables that we need.

anyone have any other ideas for storing the data? I am content with other opinions or solutions.

yzguy commented 10 years ago

Can SQLite handle all those I/O operations?

brettlangdon commented 10 years ago

@yzguy all what I/O operations? probably not going to be overly intensive application, but yes, it should be able to.

yzguy commented 10 years ago

Sounds good then, if we found out that it couldn't then I'm sure it wouldn't be too bad to change it over.

brettlangdon commented 10 years ago

@yzguy right, as long as we develop a fairly generic interface for data access, shouldn't be a big deal to switch to something else