Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Fast relational database for simple use with Python [closed]

For my link scraping program (written in python3.3) I want to use a database to store around 100.000 websites:

  • just the URL,
  • a time stamp
  • and for each website a list of several properties

I don't have knowledge about databases, but found the following may fit my purpose:

  • Postgresql
  • SQLite
  • Firebird

I'm interested in speed (to access the database and to get the wanted information). For example: for website x does property y exist and if yes read it. The speed of writing is of course also important.

My question: Are there big differences in speed or does it not matter for my small program? Maybe someone can tell which database fits my requirements (and is easy to handle with Python).

like image 707
zwieback86 Avatar asked Aug 06 '13 18:08

zwieback86


1 Answers

The size and scale of your database is not particularly large, and it's well within the scope of almost any off-the-shelf database solution.

Basically, what you're going to do is install the database server on your machine and it will come up on a given port. You then can install a library in Python to access it.

For example, if you want to use Postgresql, you'll install it on your machine and it will come up attached to some port like 5000, or port 5432.

But if you just have the information you're talking about to store and retrieve, you probably want to go with a NoSQL solution because it's very easy.

For example, you can install mongodb on your server, then install pymongo. The tutorial for pymongo will teach you pretty much everything you need for your application.

like image 94
kentquirk Avatar answered Oct 21 '22 09:10

kentquirk