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. You also have access to embedded instructions for all use aspects, including multi-database management, setting up SQL triggers, and properly executing SQL scripts.Project Name: Graphical Query Builder for pgAdmin III There is also a ‘Query Tool Macros’ for performing pre-defined SQL queries in as little as a single keypress. This option visually builds SQL queries and executes or saves them to a TXT file. PgAdmin 4 additionally provides you with a Graphical Query Builder (GQB) option. It includes many useful features, including syntax highlighting, SQL editor, procedural code debugger, and a server-side code editor, to name a few. You can perform different actions like running simple SQL queries to developing complex databases. pgAdmin 4 provides a powerful graphical interface that simplifies the creation, maintenance, and use of database objects. pgAdmin is designed for both novice and experienced Postgres users alike. It allows you to write simple SQL queries or develop complex databases, all with PostgreSQL functions. PgAdmin 4 allows multi-database management through an administration interface for PostgreSQL permitting statements, procedure viewing, and more.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |