Experiences with "Existing External" database query & updates?

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Experiences with "Existing External" database query & updates?

Post by tford »

Hi All,

Tipping my toe back into the forum waters.

I'm interesting in learning about any and all experiences you have with "existing external" persistence DBs.

What positive or negative experiences have you had? Limitations you experienced? Cool things you've done?

We have a Postgres DB that I'm considering leveraging Aware IM if it turns out to be the best tool for the job.

I'm particularly interested in your experiences with filtering in queries & being able to update records in the "existing external" DB.

Thanks!
Tom - V8.8 build 3137 - MySql / PostGres
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Experiences with "Existing External" database query & updates?

Post by BLOMASKY »

It just works. Now the limitations, you can NOT add any fields in the aware connection to the DB EXCEPT for shortcuts and that assumes that a foreign key was defined in the External file. Also, if you change the external file, you have to "Discover" the fields again, but thats not a problem. I have an app where I use the external files for both queries and updates.

Bruce
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Experiences with "Existing External" database query & updates?

Post by tford »

Thanks much, Bruce!

Years ago when I used Aware on an external DB, my vague recollection is when re-discovering attributes when changes in the DB happened, then queries would break and have to be redefined.

Can you confirm that nothing breaks when re-discovering?

Great to hear about shortcuts when foreign keys are defined. Again, I don't think that was the case years ago, but I could be wrong.

Also, do filters work?
Tom - V8.8 build 3137 - MySql / PostGres
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Experiences with "Existing External" database query & updates?

Post by tford »

Bruce,

Have you attached Aware to views? If so, standard views or materialized views?
Tom - V8.8 build 3137 - MySql / PostGres
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Experiences with "Existing External" database query & updates?

Post by BLOMASKY »

I have used Aware External DBs with Views, but only standard views.

Bruce
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Experiences with "Existing External" database query & updates?

Post by tford »

Thanks Bruce,

Can you confirm that nothing breaks when re-discovering? Years ago when I used Aware on an external DB, my vague recollection is when re-discovering attributes when changes in the DB happened, then queries would break and have to be redefined.

Do AwareIM filters work?
Tom - V8.8 build 3137 - MySql / PostGres
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Experiences with "Existing External" database query & updates?

Post by BLOMASKY »

I have had to "rediscover" often. Esp. when new columns are added to underlying database. (Which happens too often!)
Shortcuts have to be re-created but otherwise all is good.

Bruce
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Experiences with "Existing External" database query & updates?

Post by tford »

Hey Bruce,

Doesn't the need to recreate shortcuts break queries where the shortcuts were used?

Thanks!
Tom - V8.8 build 3137 - MySql / PostGres
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Experiences with "Existing External" database query & updates?

Post by BLOMASKY »

my bad memory says as long as the same name it worked. But, I have NO memory!



Bruce
gernotlg
Posts: 80
Joined: Fri Aug 27, 2021 1:24 am

Re: Experiences with "Existing External" database query & updates?

Post by gernotlg »

I connect to external. Doesn't seem to be a problem with rediscovering aside from a lesson I learned early.. which is to just do your formatting in the query, not the BO attributes because they'll all go back to whatever the default is.
V8.8 / Windows / MySQL
Post Reply