![]() In conclusion there will be a pane for the “Drawing Area” (with tables, views and subqueries), a dialog “Table Properties” (table properties, columns list, constraints list, grouping and sorting criteria) and a dialog “Column Properties” (column alias, unique or distinct, aggregate function) The user will be able to group and sort the retrieved data.It will be possible with a tree organization of the restrictions, i.e.: When selecting restrictions (where clause), it will be possible to use nested restrictions and each restriction will be according to the attribute type.A subquery will be represented as a table with a diagram inside it and it will be edited in another pane. The user will be able to use subqueries. ![]() The columns retrieved could also be aggregate functions about an attribute. The user will be able to select the attributes (or columns) to be retrieved, the alias to be used and if the attribute retrieved will be unique or not.Each table will be represented as a rectangle with its name at the top, and the attributes will be shown at the bottom of the rectangle.Some Query builders forces the user to redefine the relations between two objects but this information is stored in the PostgreSQL Server and could be used in order to allow the user concentrate in the data to be retrieved.The tables and views could be dragged from the objects tree view (left side of the main window) to the “Drawing Area” in order to add them to the diagram, the Window also will have a button to add tables and views.It can be integrated to the “pgAdmin III Query window”.It is required a Graphical Query Builder for pgAdmin III, so the specifications for my project are: PostgreSQL administrators will be able to retrieve different information faster each time it is needed and developers will be able to build queries taking care on the information wanted without syntax or naming errors. It will be useful inside pgAdmin because the user will be able to build complex SQL queries in a shorter time. The Graphical Query Builder is an idea listed in the PostgreSQL ideas page, and I think this project will be interesting for the facility on building SQL queries by a visual interface. Why would a PostgreSQL user, administrator or developer care about this project? My preferred programming languages are C, C++ and Java.Īnother reason I feel I’m the correct person to work on this project is that I will be a full time developer for the Summer of Code, because I’m a last year undergraduated student and my studies goes until end of April, so I can participate in this program and I would like to continue contributing in the pgAdmin project after the end of the program. I was an ICPC-ACM contestant in the South American Region in the last two years. I am a Freebsd and MS Windows user, and as a developer in MS Windows Environment I prefer the use of use multiplatform tools (gcc, vim, etc.), libraries (opencv, opengl, etc.) and GUI libraries (gtk, QT, etc.), so I think I match with pgAdmin Multiplatform idea. NET) for this project currently I’m reviewing wxWidgets, and it doesn’t seems to be very different. I am also familiar with some GUI libraries (like: gtk, QT, Swing, Java AWT, MS Visual Studio 6 and. Why do you feel that you are the correct person to work on this project?Īs mentioned above, I have experience developing a CASE tool, so I’m familiar with the developing of this kind of applications. Yes, in my course work I have developed, as part of a team, a CASE tool for designing database models complemented by two restrictions languages: (i) Transactional Language and, (ii) Restrictions Language. Have you already done any work on this project? And, with this project I could get started as a contributor for the PostgreSQL and pgAdmin projects. I also expect to learn how the development of free-software occurs. PgAdmin is the most used interface to PostgreSQL database, and I expect to develop this Graphical Query Builder to bring pgAdmin with this new feature. ![]() Please explain in one paragraph what you expect to accomplish with this project: Project Summary: I will develop a Graphical Query Builder for pgAdmin in order to build complex SQL queries from the database structure. Project Name: Graphical Query Builder for pgAdmin III ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |