1. B M
  2. Valentina Studio
  3. Saturday, December 30 2017, 05:52 PM
  4.  Subscribe via email
I like Valentina Studio Pro A LOT. To complete my love fest with this app, however, I would like to ask a couple of questions in relation to PostgreSQL support in it:

1. Currently it seems that Valentina does not recognize foreign tables in PostgreSQL which are their own entity in the database itself. I can run views based off of foreign tables but I cannot see foreign tables themselves. A quick comparison between pgAdmin and Valentina Studio will reveal what I am talking about here. So my question is: "Is there enough interest in your community that would trigger adding of that feature to your studio?"

2. Along the same lines, I have a question related to creating of foreign servers/extensions. Again, comparison between pgAdmin and Studio will reveal missing objects in Valentina. Will you ever plan on adding them? I don't want tot take anything away from your own Valentina database but I really like PostgreSQL.

3. The last piece that would be a complete killer of pgAdmin for me would be PostgreSQL schedule which is added to pgAdmin via pgJobs module. It enables me to create jobs in PostgreSQL in a similar fashion you do cron jobs on UNIX (with extra of more flexibility than a cron).

If those three extra pieces ever find their way to your studio, I really believe that there would be no reason for anyone to look at pgAdmin 4 and beyond because as I said in my other post, v4 was a huge step back from my perspective as a user and a developer exercise in finding out if it can be written as a 'web app' sacrificing user experience.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Yes, it is interesting, thank you.
1. How do you use the foreign tables - mostly for viewing the data or for editing, too?
2. Servers which are used to create foreign tables? And extensions created by CREATE EXTENSION statement?
3. Never heard about pgJobs, could you please give us a link to read about it?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
B M Accepted Answer
Yes, it is interesting, thank you.
1. How do you use the foreign tables - mostly for viewing the data or for editing, too?
2. Servers which are used to create foreign tables? And extensions created by CREATE EXTENSION statement?
3. Never heard about pgJobs, could you please give us a link to read about it?


I will start with #3.
Here is the link to the site for pgAdmin: https://www.pgadmin.org/download/. I have to apologize for misnaming the actual module. It is not pgJobs but pgAgent which performs and provides user interface to schedule PostgreSQL jobs. From the site itself:

"pgAgent
pgAgent is a job scheduler for PostgreSQL which may be managed using pgAdmin. Prior to pgAdmin v1.9, pgAgent shipped as part of pgAdmin. From pgAdmin v1.9 onwards, pgAgent is shipped as a separate application."

#1
Most of the times foreign tables would be used as means to connect to remote databases (similar to Oracle db links) and read data from them in any capacity (e.g. you can join it against local tables, etc.). However it is not reserved just for reading. It can be by-directional if rights are granted (extensions, server, and user mapping come into play here) one can potential modify data in a remote table as well.

#2 Yes on all counts indeed.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
B M Accepted Answer
There is one more important aspect of foreign table support missing in Valentina studio. Although I can create foreign extensions, servers, user mappings and tables through the studio, I cannot see them! Just imagine. Here is a perfect case scenario to illustrate it:

In Valentina studio query window:

CREATE EXTENSION postgres_fdw;
CREATE SERVER thunder FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host '192.168.0.25', dbname 'homeapps', port '5432');
CREATE USER MAPPING FOR userfoo SERVER thunder OPTIONS (user 'userfoo', password 'secret');
IMPORT FOREIGN SCHEMA public LIMIT TO (comp_address, company, orders, products)
FROM SERVER thunder INTO my_foreign_schemar;

So, after executing above, I would have 4 tables under the "foreign table" structure listed in pgAdmin. However, Valentina shows 0 tables under its own table folder. I can query them, but I cannot see them. Bummer. The only way around is to create a 'view' so I actually can remember what foreign tables I've created. I hope you see my dilemma here. I wish to avoid jumping back and forth the Studio and pgAdmin to consult what I actually create.

I hope that you will add this functionality soon to your PostgreSQL support. Many thanks again for your support.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Sergey Pashkov Accepted Answer
Hello,
Thanks for the example.
Yes, we'll try to implement it ASAP.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
Hello,

Yet another vote for the foreign data tables.

I am considering to change from SqlMaestro, but my principal project heavily relies on foreign tables, that are visually not assisted by Valentina. As the foreign database is not even mine, I have quite a trouble to work with Valentina Studio.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories