Scholarlink

Before we begin utilizing application data and user interaction insights, we must first understand how to store and manage data of varying schemas persistently using robust and distributed database systems in an organized manner. This chapter will focus on two types of database systems: relational and nonrelational. We will demonstrate use cases for each by interfacing with PostgreSQL and MongoDB. Additionally, advanced features such as fuzzy matching and full-text indexing will be introduced, with boilerplate code provided as building blocks for your own applications. Finally, you will learn how to seamlessly integrate these databases with Streamlit to visualize data and perform create, read, update, and delete (CRUD) operations. For full comprehension of this chapter, the installation of PostgreSQL and pgAdmin is required.

错误：搜索内容不能为空，请输入英文关键词
错误：关键词超出字数限制，请精简
高级检索

Integrating Databases

  • 章节

  • 发表日期：

    2025年

查看全文
  • Mohammad Khorasani,
  • Mohamed Abdou,
  • Javier Hernández Fernández

摘要

Before we begin utilizing application data and user interaction insights, we must first understand how to store and manage data of varying schemas persistently using robust and distributed database systems in an organized manner. This chapter will focus on two types of database systems: relational and nonrelational. We will demonstrate use cases for each by interfacing with PostgreSQL and MongoDB. Additionally, advanced features such as fuzzy matching and full-text indexing will be introduced, with boilerplate code provided as building blocks for your own applications. Finally, you will learn how to seamlessly integrate these databases with Streamlit to visualize data and perform create, read, update, and delete (CRUD) operations. For full comprehension of this chapter, the installation of PostgreSQL and pgAdmin is required.