Graph DB

[Thomas Sanchez]

Hi guys,

The more I dig the graphDB the more I think it is what we want to
achieve but it is also kinda heavy to embed in an app (impossible
actually). I wonder, since our operations are quite simple, if we can
mimic some of the features with sqlite or another db:
- Bulbs is much more light than I expected, actually it is only a
thin python layer to map some python type into a db. There are also
connector for 2 dbs and that's it.
The gremlin support must be in the database.
- There are several graph db out there but they are all in Java. I
stumbled upon vertexdb, but I not a 100% fan;
- What would be really nice is the possibility to embed the db in
the app and not have an external daemon to run when we want to lookup
some template.

If it is ok with you, I wonder what SqlAlchemy has to offer to address
this problem?

If I sum up quickly:
- we want to be able to map Python structure into a db;
- get the relations between them obeying to some constraints;
- embedded in the application

What I can do:
- Define the datastructure we want in the db;
- define the datastructure interface;
- Map the datastructure with sqlachemy (sqlite backend?);
- Implement the interface as requests in the db.

Any comments ? Thoughts ?

Cheers,

--
Thomas Sanchez

[Lionel Auroux]

David and I talk a lot about this. I read tutos about SQLAlchemy.
This ORM seems to fit our needs. We need more experimentation on it.
I propose to continue my  development on a compiler backbone to complete my current AST. In parallel, on these AST, you (david, newton & you) could design a DB that allow us to store them, and provide or ease generation. You could also continue to investigate on graphDB, it 's kind of strange that nobody develop a standalone solution. I know that adrien candiotti began a little graphDB project in C++, but I don't know if the project is not dead.

2013/11/10 Thomas Sanchez <thomas...@gmail.com>

--
--
ML Rathaxes
www.rathaxes.org

---
You received this message because you are subscribed to the Google Groups "Rathaxes Development List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rathaxes-deve...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Cordialement,
Lionel Auroux

[Thomas Sanchez]

Ok, i'll work on it and let you know asap.


2013/11/10 Lionel Auroux <lionel...@gmail.com>:

Thomas Sanchez

[Auclair Vincent]

Hello,

the problem with sqlalchemy is kinda the same.

the difference between local db (sqlite) and distant (pgsql/mysql) is going to be horrible, many features are db-specific.

The code is just going to be horrible. I don't have any alternative for the moment, will look into that.

Vincent Auclair        -      auclair.vincent[ at ]gmail.com
(+33) 6 71 55 02 37

[Lionel Auroux]

We could just do direct sqllite calls?

2013/11/10 Auclair Vincent <auclair...@gmail.com>

--
Cordialement,
Lionel Auroux

[Thomas Sanchez]

we're discussing with Vincent.

In the end we will need to test and experiment. Whether we choose to
use a thin layer like sqlalchemy or not this should be visible from
outside

2013/11/10 Lionel Auroux <lionel...@gmail.com>:

[Louis Opter]

On Sun, 10 Nov 2013 17:35:15 +0100
Auclair Vincent <auclair...@gmail.com> wrote:

> Hello,
>
> the problem with sqlalchemy is kinda the same.
> the difference between local db (sqlite) and distant (pgsql/mysql) is
> going to be horrible, many features are db-specific.

I don't see how this will be different from any other db system we pick?

If you want/need to do SQL in Python, then SQLAlchemy the way to go.

--
Louis Opter