GeoSQL

About the Project • Built With • Contributing • Usage • License • Contact • Acknowledgements

? About the Project

Learning database usages and tools can often prove to be a daunting task. Students face many new and exotic concepts in doing so, which may hinder the process.

With the objective of easing the learning curve, GeoSQL was born and improved as a practicing tool of SQL, the main language that Database Management Systems use on their task of communicating with databases. It is a powerful system, providing users with robust and varied databases, handling of complex queries and visual representation and customization of the results.

It is expected that, with such tools, the vital knowledge of database applications will be sped up and made easier to acquire and disseminate.

? Built With

• NodeJS
• ReactJS
• PostgreSQL
• Openlayers
• TypeScript

Contributing

GeoSQL is an open source project. If you have the interest in contributing, you can do so either by contacting us directly (e-mails at a later section) or making direct changes to the platform via pull requests:

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Commit your Changes (git commit -m 'Add some AmazingFeature')
4. Push to the Branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

Some information regarding the development environment of the application:

• Frontend: Port 3000
• Backend: Port 3333
• REACT_APP_BASE_URL: base url used by react router if the application is under some route like http://www.example.com/geosql
• REACT_APP_API_URL: represents the backend public url, where axios can find the api

Usage

The platform is available for use at http://aqui.io/geosql/. The help page offers an extensive tutorial on the features and tools of the system.

License

This project is under the GNU v2 license.

? Contact

If you like the project and have the interest in contacting the responsibles directly, please send an email to [email protected] or [email protected] with the subject "GeoSQL".

? Acknowledgments

This platform is the product of a Scientific Initiation project developed at the Departamento de Ciência da Computação (DCC) of the Universidade Federal de Minas Gerais (UFMG). As such, it would not be possible without the sponsorship of the Conselho Nacional de Desenvolvimento Científico e Tecnológico (CNPq) and the guidance of Clodoveu Davis A. Júnior.