Discover how to install PostgreSQL on Windows and Mac OS, set up a database using pgAdmin or Command Line, and interact with PostgreSQL through shell commands. Learn step-by-step instructions for installation and database creation to kickstart your PostgreSQL journey.

7 views • 9 slides

This project involves creating a Microsoft Hololens heads-up display for an interactive tour of the ASU campus. It includes showcasing landmarks and a Twitter feed displaying geo-tagged tweets. The motivation stems from enhancing self-guided tour experiences for prospective students, potentially aid

1 views • 15 slides

Explore the challenges and solutions for horizontally scaling RDBMS like PostgreSQL on Amazon servers, considering factors such as data distribution and multi-tenancy. Delve into the complexities of H-Scaling and the trade-offs between relational and non-relational databases in terms of performance

3 views • 16 slides

Learn the essentials of web scraping using Python to extract data efficiently. Python's versatility shines in web programming and data management, allowing for a seamless research pipeline. Explore different approaches to web scraping in Python and understand the importance of managing data effectiv

9 views • 19 slides

Learn how to set up DHIS2 Live on Windows machines for testing purposes, not production servers. Follow step-by-step instructions to install Java, PostgreSQL, add PostgreSQL to Windows path, configure PgAdmin, edit configuration files, and start DHIS2. Includes images for clarity.

0 views • 11 slides

Detailed guide on setting up DHIS2 Live on Windows laptops or desktops, including installation of Java and PostgreSQL, configuration steps like adding PostgreSQL to the system path, setting up databases, loading demo data, and configuring the DHIS2 Live package for use. Follow these instructions car

5 views • 12 slides

Explore how Alibaba provides PostgreSQL as a cloud service in Guangzhou, focusing on technical details, background about PG in Alibaba, issues faced, solutions implemented, and future directions. Learn about Alibaba's use of PostgreSQL in its internet businesses and as a replacement for Oracle, alon

0 views • 30 slides

Learn how to install and configure DHIS2.Live on Windows laptops and desktops for testing purposes, including setting up Java, PostgreSQL, adding to the Windows path, configuring PgAdmin, and preparing the demo database. Follow step-by-step instructions and images to successfully set up DHIS2.Live o

0 views • 12 slides

A real-time system with an interactive web interface for managing campus facilities, extending the scope of a previous project. Stakeholders include campus visitors, lessees, and organizational management, with features like facility monitoring and an architecture shift to PostgreSQL and MongoDB wit

0 views • 12 slides

Learn how to install PostgreSQL on Windows and Mac OS, set up a superuser password, create a database using pgAdmin or Command Line, and execute basic shell commands for database management. This guide provides step-by-step instructions for a seamless installation process.

1 views • 9 slides

This project focuses on upgrading and enhancing the license management system at the Joint Institute for Nuclear Research in Dubna. It addresses challenges related to optimizing license usage through different types of licenses and monitoring systems. The system architecture includes components like

0 views • 18 slides

Veerendra Pulapa, a Technical Consultant at Ashnik with 6+ years of experience, highlights how unused indexes, fragmentation, and idle connections can slow down database performance. He emphasizes the importance of database maintenance in PostgreSQL operations for optimal performance and reduced dow

0 views • 17 slides