Synonyms / Symbolic Links for tables?

Feedback
1

Describe the problem you’re experiencing?
Our database is in a fair amount of flux as we build out our applications ; sometimes we need to build new versions of tables in parallel to our existing live table but end up having to update all our code to point to the new table.

What is your ideal solution? What are you looking for?
It would be great if we could have a ‘symbolic link’ to the real table…
ie: We name our tables _v1, v2 etc etc
The Link

would point to whichever is our Current live version of the table

What version(s) of MemSQL or related tools is this affecting?

2

We’re tracking this as a feature request. Thanks.

For read access, you can use a view to accomplish this. Presumably you want to do updates too, is that right?

3

Hi Hanson,

This is for full Select/Insert/Update/Delete access to a table using a generic name.

Regards,
Nick

4

A possible nice to have might also be if the synonym was user specific. The use case would be where some users are testing _v2 while others are developing _v3 in the same schema, but both have application code pointing _vCurrent. While the same could be accomplished by creating separate schemas or databases, that’s not always cost / time efficient if there’s a lot of ancillary data or set up in creating a second schema.

5

@michael.arthur I took note of that.