[Maria-discuss] new kind of plugin
Hi guys, I was thinking about a new kind of plugin, a field type plugin... i think it's a relative interesting idea... about sintax:
ALTER TABLE table ADD field PLUGIN("plugin_name","version","field_type","parameters") NOT NULL/NULL DEFAULT 'something' AUTOINCREMENT, etc..
an example...
ALTER TABLE table ADD field PLUGIN("crypt","1","somecrypto","size=255") NOT NULL DEFAULT 'something'
internally (to storage engine) this kind of data will be saved as blob (for example), and to client side it will be a blob too
when i use: insert into table(field) values ("some text"); and select * from table
i will get "some text" but internally (at filesystem) the value is save as a crypto of "some text" --- other idea is compress
ADD field PLUGIN("crypt","1","compress","size=255") NOT NULL DEFAULT 'something'
internally it will be saved as varchar(255), when i execute insert it will compress the value and when i select it will uncompress the value
the parameters for this new field type is: PLUGIN(plugin name, plugin version, plugin field name, parameters)
plugin name is the plugin name... plugin version is important to execute alter table, or when using diferent kind of plugin versions we could know what version is being used and execute a automatic alter table for example... plugin field is the type of field in this plugin parameters are parameters for plugin values
another idea is a enum with external table... ADD field PLUGIN("external_enum",'1','enum','table=database.table,id=field_id,value=field_value')
it will execute a SELECT internally to table "database.table" and return the id/value of that table id is a bigint/int/mediumint/smallint/tinyint value (like enum index) and value is a string value (varchar,char,longtext,text)
to storage engine will be used a bigint, for user it will be used as a enum() field
------ thre's more examples with interesting things, like expand opengis, or add others kind of field types, but the main idea is create a plugin interface for field types
what you say guys?
bye =)
Hi, Roberto!
On Aug 16, Roberto Spadim wrote:
Hi guys, I was thinking about a new kind of plugin, a field type plugin... i think ------ thre's more examples with interesting things, like expand opengis, or add others kind of field types, but the main idea is create a plugin interface for field types
what you say guys?
Yes, I thought about it. It looked very promising, but I never got around to implementing this.
Regards, Sergei
nice... i'm with some doubts about JIRA... normally a issue tracker allow users to add feature request and bugs (maybe more issues...) bugs is normally open to any user feature request sometimes...
i openned many mdevs and didn't start any work, i know it something add fuzzy to dashboards there's a 'workflow' to add a feature request? for example, first ask in maria-discuss after maria-developer and after add to jira? or just add the idea to jira is ok? i want to write the description to jira but i don't know if i should do this, because i will add something that maybe anybody will read and know about it
my idea here is add a new field type (PLUGIN) and field informations, this will be added to .frm file, to storage engine it will work with default mariadb field types (char,blob,int,geometry,enum,set,decimal,float...), to internal it will add a layer to read/set/compare values (i don't know how it's done today) this is very usefull... is was reading about "add IPv6 FIELD type, add IPv4 FIELD type, add XYZ FIELD type", for disk it's just bytes... but for dba/developer/archtect it's more than just bytes, it's database features, and make some diference when one arch select one database or another database... (just to don't forget the alread need point of this plugin)
well i don't know if i'm clear :) but i think it's very nice :D i have many ideas in my head and i think it'is better stop writing for now or i will do a brain storm here kkkkk
about add to jira, should i add this one there?
Hi,
I think a well defined user defined type interface would be welcome. PgSQL has a pretty good implementation you may want to look at.
--Justin
On Sat, Aug 17, 2013 at 10:31 AM, Roberto Spadim roberto@spadim.com.brwrote:
nice... i'm with some doubts about JIRA... normally a issue tracker allow users to add feature request and bugs (maybe more issues...) bugs is normally open to any user feature request sometimes...
i openned many mdevs and didn't start any work, i know it something add fuzzy to dashboards there's a 'workflow' to add a feature request? for example, first ask in maria-discuss after maria-developer and after add to jira? or just add the idea to jira is ok? i want to write the description to jira but i don't know if i should do this, because i will add something that maybe anybody will read and know about it
my idea here is add a new field type (PLUGIN) and field informations, this will be added to .frm file, to storage engine it will work with default mariadb field types (char,blob,int,geometry,enum,set,decimal,float...), to internal it will add a layer to read/set/compare values (i don't know how it's done today) this is very usefull... is was reading about "add IPv6 FIELD type, add IPv4 FIELD type, add XYZ FIELD type", for disk it's just bytes... but for dba/developer/archtect it's more than just bytes, it's database features, and make some diference when one arch select one database or another database... (just to don't forget the alread need point of this plugin)
well i don't know if i'm clear :) but i think it's very nice :D i have many ideas in my head and i think it'is better stop writing for now or i will do a brain storm here kkkkk
about add to jira, should i add this one there?
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
https://mariadb.atlassian.net/browse/MDEV-4912 i added this MDEV, and i'm linking to MDEV about new field types my description is very ugly, maybe someone with more know about internall source could help :)
i iwll link information about PGSQL to better explain who want to implement this MDEV
2013/8/17 Justin Swanhart greenlion@gmail.com
Hi,
I think a well defined user defined type interface would be welcome. PgSQL has a pretty good implementation you may want to look at.
--Justin
On Sat, Aug 17, 2013 at 10:31 AM, Roberto Spadim roberto@spadim.com.brwrote:
nice... i'm with some doubts about JIRA... normally a issue tracker allow users to add feature request and bugs (maybe more issues...) bugs is normally open to any user feature request sometimes...
i openned many mdevs and didn't start any work, i know it something add fuzzy to dashboards there's a 'workflow' to add a feature request? for example, first ask in maria-discuss after maria-developer and after add to jira? or just add the idea to jira is ok? i want to write the description to jira but i don't know if i should do this, because i will add something that maybe anybody will read and know about it
my idea here is add a new field type (PLUGIN) and field informations, this will be added to .frm file, to storage engine it will work with default mariadb field types (char,blob,int,geometry,enum,set,decimal,float...), to internal it will add a layer to read/set/compare values (i don't know how it's done today) this is very usefull... is was reading about "add IPv6 FIELD type, add IPv4 FIELD type, add XYZ FIELD type", for disk it's just bytes... but for dba/developer/archtect it's more than just bytes, it's database features, and make some diference when one arch select one database or another database... (just to don't forget the alread need point of this plugin)
well i don't know if i'm clear :) but i think it's very nice :D i have many ideas in my head and i think it'is better stop writing for now or i will do a brain storm here kkkkk
about add to jira, should i add this one there?
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
well some better write text is in mdev now if anyone with time could add more informatino about it could be nice and maybe we could start some work about it
2013/8/17 Roberto Spadim roberto@spadim.com.br
https://mariadb.atlassian.net/browse/MDEV-4912 i added this MDEV, and i'm linking to MDEV about new field types my description is very ugly, maybe someone with more know about internall source could help :)
i iwll link information about PGSQL to better explain who want to implement this MDEV
2013/8/17 Justin Swanhart greenlion@gmail.com
Hi,
I think a well defined user defined type interface would be welcome. PgSQL has a pretty good implementation you may want to look at.
--Justin
On Sat, Aug 17, 2013 at 10:31 AM, Roberto Spadim roberto@spadim.com.brwrote:
nice... i'm with some doubts about JIRA... normally a issue tracker allow users to add feature request and bugs (maybe more issues...) bugs is normally open to any user feature request sometimes...
i openned many mdevs and didn't start any work, i know it something add fuzzy to dashboards there's a 'workflow' to add a feature request? for example, first ask in maria-discuss after maria-developer and after add to jira? or just add the idea to jira is ok? i want to write the description to jira but i don't know if i should do this, because i will add something that maybe anybody will read and know about it
my idea here is add a new field type (PLUGIN) and field informations, this will be added to .frm file, to storage engine it will work with default mariadb field types (char,blob,int,geometry,enum,set,decimal,float...), to internal it will add a layer to read/set/compare values (i don't know how it's done today) this is very usefull... is was reading about "add IPv6 FIELD type, add IPv4 FIELD type, add XYZ FIELD type", for disk it's just bytes... but for dba/developer/archtect it's more than just bytes, it's database features, and make some diference when one arch select one database or another database... (just to don't forget the alread need point of this plugin)
well i don't know if i'm clear :) but i think it's very nice :D i have many ideas in my head and i think it'is better stop writing for now or i will do a brain storm here kkkkk
about add to jira, should i add this one there?
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial
participants (3)
-
Justin Swanhart -
Roberto Spadim -
Sergei Golubchik