maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

i know sqlite and mysql are very different, but at sqlite i can create
`native` functions
at mysql only with plugins

since i like a lot mariadb, i think a plugin with many usefull functions
could be enabled with some variable or some install plugin command
that help a lot, some times

for example the base64_encode/decode function was a verrrrry old feature
that i reported to mysql maybe at 2004 or 2006, but only now (2013/2014)
it`s inside mysql/mariadb code :(


2014-03-19 12:33 GMT-03:00 Reindl Harald <h.reindl@xxxxxxxxxxxxx>:

> i feel like to comment mailing-list basics
>
> * DON'T top-post, you are destryoing threads
> * DON'T convert plaintext posts to HTML
> * DON'T reply-all, the reply button results in a off-list answer
>
> Am 19.03.2014 16:25, schrieb Peter Laursen:
> > I feel like to comment here on "because it can't use indexes for such
> things".
> > This is not a serious reply IMO. It is just another way or saying
> "Please shut up!"
>
> it is serious and don't insinuate words one have not said
> there is a) no such function and b) no benefit of it
>
> > How many existing string functions (
> http://dev.mysql.com/doc/refman/5.6/en/string-functions.html) use an
> index?
> > Does "select concat('a','b');" do for instance?
>
> that does not read and seek anything in a column
> frankly "select concat('a','b');" is the same as "ab"
>
> > I cannot think of any. And why do we have 'stored programs' if a
> > database server should only do things that uses indexes? Does a
> > WHILE-loop inside a stroed program use an index?
>
> surely can someone discuss what should be donme
>
> > Unlike most other RDBMS, MySQL has a tradition to do things in the
> application thet other RDBMS would do in the
> > database. But that traditions is/was because of lack of functionality in
> the server before 5.0 (what is still the
> > case in some respects.  Try compare a MySQL TRIGGER with an Oracle or
> SQL Server same, for instance).
> >
> > That said: this functionality can be implemented in a stored function
> using existing string functions (or in the
> > application, as sugggested) quite easily
>
> maybe
>
> > It is not possible (or desirable) to add build-in functions for
> everything
>
> which was my point
>
> > And I have no clue is such string function exists in other RDBMS.
>
> unlikely
>
> > On Wed, Mar 19, 2014 at 4:03 PM, Reindl Harald <h.reindl@xxxxxxxxxxxxx<mailto:
> h.reindl@xxxxxxxxxxxxx>> wrote:
> >
> >     Am 19.03.2014 15:51, schrieb Roberto Spadim:
> >     > hi guys, i'm not finding a function to return how many character i
> have, for example:
> >     >
> >     > "banana"
> >     >
> >     > i want a function that return 2 "n" characters, example:
> >     > substr_count("banana","n") => 2
> >     >
> >     > sorry it a begginners question, but i didn't found it in
> mysql/mariadb manual
> >
> >     that is not the job of the database server because it
> >     can't use indexes for such things - just iterate
> >     the result and do it in the application
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle