[Maria-discuss] New Question: What's the chance of a true Boolean data type in MariaDB?

2015-01-29 Thread AskMonty KB
Hello, A new question has been asked in "MariaDB Community" by RobLewis. Please answer it at http://mariadb.com/kb/en/whats-the-chance-of-a-true-boolean-data-type-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. As a MySQ

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-29 Thread Roberto Spadim
Hi Oleksandr!! :) Hi, Roberto! > >> at "value" parameter, COLUMN_CREATE know that we are using a STRING, but >> should be any other data type >> >> The *|as type|* part allows one to specify the value type. In most cases, >> this is redundant because MariaDB will be able to deduce the type of the

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-29 Thread Oleksandr Byelkin
Hi, Roberto! On 29.01.15 15:55, Roberto Spadim wrote: 2015-01-29 12:34 GMT-02:00 Tom Worster >: I have one final technical question. It is for my understanding and does not reflect a problem I have as a user. The manual says: > The answer is: SQL is

[Maria-discuss] MariaDB Galera Cluster 10.0.16 now available

2015-01-29 Thread Daniel Bartholomew
The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.16 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.16 - Releas

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-29 Thread Roberto Spadim
one point... at the COLUMN_GET() at SELECT part of query mysql protocol, need one specific data type to send to client side this example: SELECT CONCAT('blabla', COLUMN_GET()), COLUMN_GET() 1st column: CONCAT return string, column_get isn't a problem here 2nd column: COLUMN_GET will retur

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-29 Thread Roberto Spadim
2015-01-29 12:34 GMT-02:00 Tom Worster : > I have one final technical question. It is for my understanding and does > not reflect a problem I have as a user. > > The manual says: > > > The answer is: SQL is a statically-typed language. The SQL interpreter > needs to know the datatypes of all expre

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-29 Thread Tom Worster
I'm going to respond to your previous two emails with a generality: It is sometimes better to optimize the software development process than the software's data processing. If this were not true, I would not be using this ORM at all and nobody should. But the converse is also clear: sometimes the

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-29 Thread Tom Worster
I have one final technical question. It is for my understanding and does not reflect a problem I have as a user. The manual says: > The answer is: SQL is a statically-typed language. The SQL interpreter needs to know the datatypes of all expressions before the query is run (for example, when one

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-29 Thread Roberto Spadim
2015-01-29 11:57 GMT-02:00 Tom Worster : > Hi Oleksandr, > > I'm going to stop bitching about Maria now. My needs are in fact met by > the current dyncol functions: > > - It's not so hard to write methods that generate CREATE_COLUMN() > expressions from a general data structure. > > - COLUMN_JSON(

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-29 Thread Roberto Spadim
2015-01-29 11:38 GMT-02:00 Tom Worster : > Hi Frederico, > > You identify three problems. > > 1. Developers are mostly ignorant of dynamic column or that they can solve > this problem. I agree. > hum, i will point some problems and ideas... normally developers don't think about how data is saved a

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-29 Thread Tom Worster
Hi Oleksandr, I'm going to stop bitching about Maria now. My needs are in fact met by the current dyncol functions: - It's not so hard to write methods that generate CREATE_COLUMN() expressions from a general data structure. - COLUMN_JSON() is just fine for all my reading purposes. I see no need

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-29 Thread Tom Worster
Hi Frederico, You identify three problems. 1. Developers are mostly ignorant of dynamic column or that they can solve this problem. I agree. 2. Maria's interface is not easy. I agree but my opinion has changed during this discussion. There's a limit to what the server can do about this. Also, th

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-29 Thread Tom Worster
Hi Adam, Yes, application developers encounter that problem a lot. Please read the Motivation section here: https://github.com/tom--/dynamic-ar/blob/master/README.md If that describes the general problem adequately to you, maybe give it a star? Tom From: Adam Scott Date: Wednesday, January