Request Summary: Adding UDFs (User-Defined Functions) Somewhere in the editor
=== Why should this be added? ===
- User-Defined Functions (UDF)'s are currently not supported by Sequel pro from
what I've been able to find.
Example:
- I've created a microtime UDF (which you can check out on github) that adds
support for a microtime to mysql 5.5 and is much faster than SYSDATE(). It
consists of a shared library named mysql_udf_microtime.so
- I've added the UDF with `CREATE FUNCTION microtime RETURNS REAL SONAME
'mysql_udf_microtime.so';`
Although it can be called with `MICROTIME()`, is not visible in the sidebar or
anywhere else in the UI
- It would be great if it was possible to view and manage UDFs In Sequel Pro
=== How should this be implemented? ===
- This I'm not completely sure on. While it can be called and deleted as other
functions, UDF's are stored once on the server and can be accessed on all
Databases. Therefore it might not make sense to include them in the Sidebar
when a database is selected, since that area is reserved for database-specific
items.
Two potential options are:
1. Show them among PROCS & FUNCS, but to give them a different icon. Maybe even
grey them out to indicate that they are server-wide, not database-specific.
This Could be a preference ("Show User-Defined Functions in sidebar for all
Databases")
2. Have a separate section in the editor, not in the sidebar. When I first
suggested it via email, Rowan replied that it might be possible to add a
'server overview' section when no database is selected, which would show
various information across all databases, including UDF's.
Original issue reported on code.google.com by josha...@gmail.com on 16 Oct 2013 at 1:03
Original issue reported on code.google.com by
josha...@gmail.com
on 16 Oct 2013 at 1:03