SQL defines a PostgreSQL table and seed rows, then selects course records. A Rust program uses sqlx to submit the query and display results in a terminal. section 4.2.2
SQL
SQL is a declarative language for defining, querying, modifying, and controlling data in relational databases.
How Rust Servers, Services, and Apps covers it
- How deep it goes
- Builds from database creation and table definition to seeded rows and a parameterized sqlx query, without developing broader SQL operations.
- Examples
- Demonstrates creating and seeding a course table, then selecting its records in psql and Rust.
- What it assumes
- Sets up PostgreSQL, credentials, a table, and a Rust data model before querying rather than assuming database connectivity.
- What you can do after
- Apply SQL through sqlx to query PostgreSQL and display returned course rows in a terminal.
- How it connects
- Connects SQL with PostgreSQL, Rust, sqlx, database tables, and asynchronous connection pools.
Also explained in
-
Data Analysis with LLMsSQL is a standardized language for defining, querying, and manipulating data in relational database systems.
-
A Pythonic Adventure: From Python basics to a working web appSQL is a standardized language for defining, querying, and manipulating data in relational databases.
-
Effective Data AnalysisA SQL query is a statement written in SQL that retrieves, filters, combines, or modifies data in a database.
-
Troubleshooting Java, Second EditionAn SQL query is a statement expressed in Structured Query Language that requests or modifies data in a database system.
-
Java Persistence with Spring Data and Hibernate epubSQL is a standardized language for defining, manipulating, querying, and controlling data in relational database systems.
-
AI Agents and ApplicationsAn SQL query is a statement written in SQL that specifies data to retrieve or filter from a relational database.
-
Build Python Web Apps with StreamlitA search query is a textual request specifying the items or information to retrieve from a search service.
-
Building Web APIs with ASP.NET CoreSQL is a standardized language for defining, querying, manipulating, and controlling data in relational database systems.
-
Pro ASP.NET Core 7, Tenth EditionSQL is a standardized language for defining, querying, manipulating, and managing data in relational databases.
-
Software Testing with Generative AIA request for information or matching items from a data collection or information-retrieval system.
-
The Well-Grounded Python Developer: How the pros use Python and FlaskSQL is a language for defining, querying, updating, and otherwise interacting with data in relational database management systems.
-
Machine Learning for Tabular Data: XGBoost, Deep Learning, and AISQL is a standardized language for querying and manipulating data in relational databases.
-
Snowflake Data EngineeringSQL is a declarative language for defining, querying, and manipulating data in relational database systems.
-
100 SQL Server Mistakes and How to Avoid ThemSQL is a declarative language for querying and managing relational data.
-
Spring Security in Action, Second EditionA database query is a structured request to retrieve or modify data in a database.
-
Django in ActionSQL is a declarative language for defining, querying, and modifying data in relational databases.
-
Kubernetes for DevelopersAn SQL query is a declarative statement that requests or manipulates data in a relational database.
-
Learn PowerShell Scripting in a Month of Lunches, Second Edition: Write and organize scripts and toolsA query is a specification of database operations or data selection expressed for execution by a database system.
-
Apache Kafka in ActionAn SQL query is a declarative statement that specifies data to retrieve, transform, or aggregate.
-
Deep Learning with R, Third EditionA query is the representation whose information need determines which keys receive high attention relevance.
-
Machine Learning System DesignA request containing terms or criteria submitted to a search engine to retrieve relevant information.
-
Go by ExampleAn SQL query is a statement expressed in SQL that requests or modifies data in a relational database.
-
Python How-ToSQL is a standardized language for defining, querying, and modifying data in relational databases.
-
The Quick Python Book, Fourth EditionAn SQL query is a statement written in SQL that requests, filters, combines, or modifies data in a database.
Compare how 25 books explain SQL →
Related concepts
- databaseuses · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
- database tableuses · A database table is a relational database structure that organizes records into rows and defined columns.
- PostgreSQLused by · PostgreSQL is an open-source object-relational database management system that implements SQL and supports transactional data storage and extensibility.
- object-relational mapperused by · An object-relational mapper is software that maps programming-language objects and operations to relational database structures and operations.
- programming languagekind of · A programming language is a formal language with defined syntax and semantics for expressing computations and instructions that computers can execute or interpret.
- declarative programmingkind of · Declarative programming is a programming paradigm that specifies desired results, states, relationships, or rules without prescribing the step-by-step operations that produce them.
This explainer was generated by Manning's knowledge graph from the text of Rust Servers, Services, and Apps. The section links point to the parts of the book it draws on.