brittneybrinsfield / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

[REQ] Adding UDFs somewhere in the UI #1829

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
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

GoogleCodeExporter commented 9 years ago
minor issue, but I forgot to include the github link: 
https://github.com/CarnotInteractive/MySQL-udf-microtime/

Original comment by josha...@gmail.com on 16 Oct 2013 at 1:04