maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

1) +1 for "ability to prepare a statement from a local variable" what I
requested 6½ years ago: http://bugs.mysql.com/bug.php?id=40038

2) I agree that no debugging facility is a serious limitation (though
Oracle claim  that their "MySQL for Visual Studio" can do it (with Visual
Studio on Windows obviously).  I have not tried).

3) another (supplementary) language for stored programs. This has been
discussed before in severalcontexts.  Problem is that there is no 'fit'
language being cross-platform. PostgreSQl has Perl, SQL Server as C#. The
current 'sp language' (for loops, conditions etc.) is based on ADA.
'Adascript' implementations (covering around 60% of full ADA, I think)
exist and could be considered.  Or LUA that looks somewhat similar. But the
interpreter will need to ship with the server.


Just my 5 cents on this!



-- Peter
-- Webyog



On Tue, Mar 3, 2015 at 12:31 PM, Federico Razzoli <federico_raz@xxxxxxxx>
wrote:

> Hi Sergej
>
> No, it was something more general. Performance is not sufficient, there is
> no debugging facility, and stored programs are not flexible enough. Arrays,
> variable number of arguments and the ability to prepare a statement from a
> local variable would help a lot. Or perhaps, the ability to use a language
> other than SQL would be a solution.
>
> I used the OR REPLACE clause to point out that both MariaDB and MySQL
> development is very slow (if any) when it comes to stored programs. As a
> user and a MariaDB lover, I think that this is a pity.
>
> Regards
> Federico
>
>
> --------------------------------------------
> Mar 3/3/15, Sergei Golubchik <serg@xxxxxxxxxxx> ha scritto:
>
>  Oggetto: Re: [Maria-discuss] stored programs
>  A: "Federico Razzoli" <federico_raz@xxxxxxxx>
>  Cc: maria-discuss@xxxxxxxxxxxxxxxxxxx
>  Data: Martedì 3 marzo 2015, 10:48
>
>  Hi, Federico!
>
>  On Mar 03, Federico Razzoli
>  wrote:
>  > Reading 10.0.3 release notes:
>  >
>  > https://mariadb.com/kb/en/mariadb/mariadb-1013-release-notes/
>  >
>  > I see that IF
>  EXISTS, IF NOT EXISTS and OR REPLACE are now almost
>  > consistent. "Almost" means
>  that... OR REPLACE still doesn't apply to
>  > stored procedures, functions, triggers,
>  events.
>
>  Support for events
>  is already pushed (albeit after 10.1.3).
>  Support for triggers will be pushed any day now
>  (already reviewed and
>  approved, so
>  there's no more work left on it). I suppose that
>  stored
>  procedures and functions will follow
>  soon.
>
>  This was a GSoC 2014
>  project that added support for these clauses to
>  *all* objects. It's just being pushed
>  piecewise, object by object.
>
>  > Recently, during a public session, a
>  PostgreSQL user asked me if
>  > MariaDB
>  supports stored procedures - in his opinion, MySQL
>  doesn't, no
>  > matter what the manual
>  says. Unfortunately my answer was that MariaDB
>  > support for stored procedure is the same
>  as MySQL ("so the answer is
>  >
>  no", he said).
>
>  I
>  don't understand what exactly missing feature that user
>  had in mind.
>  It couldn't have been
>  "CREATE OR REPLACE", this seems so minor.
>  Or was it?
>
>  Regards,
>  Sergei
>
>
> _______________________________________________
> 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
>