How to load remote database in cache, in python?

Question

I want to load a database from a remote server to my memory/cache, so that I don't have to make network calls every time I want to use the database.

I am doing this in Python and the database is cassandra. How should I do it? I have heard about memcached and beaker. Which library is best for this purpose?

Community · Accepted Answer · 2017-05-23 12:32:42Z

1

If you are trying to get some data from a database, use the pyodbc module. This module can be used to download data from a given table in a database. Answers can also be found in here.

An example how to connect:

import pyodbc
cnxn = pyodbc.connect('DRIVER={SQLServer};SERVER=SQLSRV01;
                       DATABASE=DATABASE;UID=USER;PWD=PASSWORD')
cursor = cnxn.cursor()

cursor.execute("SQL_QUERY")
for row in cursor.fetchall():
    print row

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Sep 16, 2016 at 8:54

Premysl Vorac

4836 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yashwanth Remidi Over a year ago

So this can load everything into my local cache irrespective of how large the database is?

Collectives™ on Stack Overflow

How to load remote database in cache, in python?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related