Re: sqlapi: library to connect to your erlang server via SQL
I don't think that it may be required to drop mysql support. Let it stay. I just want to say that adding _any_ new ORM is always a pain, because it has yet another way to check if there is a proper mysql on socket.
could you explain the purpose or application of your software also for
dummies like me?
Is it a kind of standalone, MySQL compatible server for ets tables?
I am just using in my project about 30 small MySQL tables to hold the
static, non functional, state of my program. Also the user interface,
implemented in HTML / PHP / JScript blablabla is using this tables to
read or set program variables and triggers.
Can I use your software instead? Or can I mirror my MySQL tables to
Erlang and vice versa ?
Am 12.03.2018 um 15:34 schrieb Max Lapshin:
> We have released our sqlapi library: https://github.com/flussonic/sqlapi >
> This library can help you to make an SQL server from your existing server.
> For example you have a server and let it be ejabberd. You want to give a
> list of connected users.
> Of course you will start from making HTTP endpoint that will reply with
> JSON with list of users.
> Then you will add some sort, filter, paging as query params and then
> will write library that allows to make all this params and send them.
> Another option is to put our sqlapi library, connect it to storage of
> connected users and then connect to server as if it is a SQL server.
> Here another real example: https://flussonic.com/doc/api/sql-cluster > User can connect to our flussonic server and access whole cluster by
> sending commands like INSERT, UPDATE, DELETE or READ.
> This approach may be convenient if you have table data and mainly CRUD
> Similar approach is used in Sphinx search engine:
> http://sphinxsearch.com/docs/latest/sphinxql.html >
> We have created all this to connect from python sqlalchemy and Ruby on
> Rails to Flussonic.
> If you want the same, this library may help.
> the only dependency is ranch and it is optional, not required for tests.
> Some code is derived from https://github.com/altenwald/myproto but we
> had to remove neotoma sql parser, because we need speed! Thanks for
> https://github.com/master/mongosql/blob/master/src/sql92_parser.yrl >
> erlang-questions mailing list
> [hidden email] > http://erlang.org/mailman/listinfo/erlang-questions >