![]() ![]() ![]() 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. Now in its third incarnation, pgAdmin remains the most popular Open Source GUI tool for managing Postgres.Project Name: Graphical Query Builder for pgAdmin III pgAdmin III looked much like pgAdmin II, but it solved all of the problems our (in particular) Japanese Linux-using friends were experiencing. The hard decision was made to rewrite everything again, this time using C++ with the wxWidgets framework. Visual Basic didn't handle internationalization or localization well, nor did it run on platforms other than Windows without the use of WINE, under which it was never particularly stable. This time it wasn't the application design that was holding us back, but rather the choice of technology. I was particularly proud of the design and cleanliness of that code, but by 2002, we needed to start over again. I shut myself away for a couple of weeks whilst my family were away visiting relatives in Scotland and wrote pgAdmin II, using a far more structured and maintainable design that implemented a much more usable user interface. Some years later, we once again found ourselves suffering due to the way the application had been designed. ![]()
0 Comments
Leave a Reply. |