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: 4214
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.7 build 3006 - MySql / PostGres
BLOMASKY
Posts: 1344
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: 4214
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.7 build 3006 - MySql / PostGres
tford
Posts: 4214
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.7 build 3006 - MySql / PostGres
BLOMASKY
Posts: 1344
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: 4214
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.7 build 3006 - MySql / PostGres
BLOMASKY
Posts: 1344
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
Post Reply