Hello everyone!!
I am trying to use OrientDB with Web2py as this GraphDocument Database
looks very promising.
It supports multi-master and automatic failover incase of any node failure
etc etc.
I am using pyorient driver inorder to connect.
IN model db.py
import pyorient
client = pyorient.OrientDB("localhost", 2424)
session_id = client.connect( "super", "super" )
client.db_open('trans', "admin", "admin" )
and then in controller default.py index function
dbs=client.db_count_records()
inorder to get number of records in database.
This is a remote binary connection from web2py to a remote orientdb
database and so the connection remains open in the database untill the we
close it from the web2py code.
My Question is, what is the proper way to do this?
Once many users are viewing the page, many connections are being opened.
Orientdb supports connection pooling. Where do I write the code for
connection pooling in web2py(should I write it in DAL), in such a way that
it won't try to create a connection for every request(opening and closing
database connection on every request is taxing, isn't it)?
Also if I want to avoid MySQL completely(currently the user login
credentials are stored in MySQL and it could be a bottle neck), can anyone
provide guidelines on how to properly rewrite DAL and what all functions in
DAL should I rewrite/add in order to get full graph db features.
I have moderate python skill.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
