David J Murray Dev
~ Learn and Do - Excel and Share ~

Further Thoughts on MySQL Proxy

Sep 29, 2007
You're Reading: Further Thoughts on MySQL Proxy

I have been thinking about how easy it would be to implement the previously mentioned idea of using MySQL Proxy as a uniVerse query processor/converter to SQL.

Now, the CREATE.FILE can be translated to a number of create table statements within SQL and DELETE.FILE to drop table respectively; and SORT to a select etc.

But, there is actually no equivalent to the SQL alter within uniVerse at the ECL or query level.

So, it becomes quite difficult to create and alter field definitions within a file.

This is actually a deficiency within the PICK/uniVerse world. Field definitions have always been done via some sort of user screen (REVISE) or editor (ED), not by a command line; either at file creation time (as in SQL) or otherwise. If the MySQL Proxy idea was to be developed, then this would have to be overcome via a new pseudo command.

It is still an interesting situation that PICK/uniVerse has never had a need (apparently) for an alter though…

About the Author

<a href="https://davidjmurray.dev/losucag/davidjmurray/" target="_self">djm</a>


I have been in the computer/IT industry for over 35 years. After spending half a life-time in highly proprietary database environments, I have succumbed to the WordPress Eco-system and I'm well down the chasm. I am specializing in AWS hosting, Wordpress CMS, Elegant Themes, in particular Divi and Extra themes.


  1. davidjmurray

    Keith, How’s it going?

    Yes, this is a solution to what I was commenting about. I will have to investigate further!




Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Pin It on Pinterest

Share This