Everything about Embedded SQL
Computer programming method
Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code, of the host language. The embedded SQL statements are parsed by an embedded SQL preprocessor and replaced by host-language calls to a code library. The output from the preprocessor is then compiled by the host compiler. This allows programmers to embed SQL statements in programs written in any number of languages such as C/C++, COBOL and Fortran. This differs from SQL-derived programming languages that don't go through discrete preprocessors, such as PL/SQL and T-SQL. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Embedded SQLA 5-minute orientation
- Pick up a classic book: Database system conceptsThe most-reprinted book on the subject
- Read the landmark paper: Detection of SQL Injection Vulnerability in Embedded SQLCited 13 times
- Go sideways: Module SQLA closely related topic
- Go sideways: ECPGA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
Detection of SQL Injection Vulnerability in Embedded SQL
Verification supported refactoring of embedded sql
Ada-embedded SQL: the options
Building Robust Fintech Reporting Systems Using JPA with Embedded SQL for Real-Time Data Accuracy and Consistency
Data processing in the UNIX environment: with INFORMIX-SQL, Embedded-SQL, C-ISAM, and TURBO
Efficient SQL querying on embedded devices using pre-compilation
Design and development of embedded/SQL home based upper limb rehabilitation
NL2SQL+: An Extended Framework for SQL Generation With On-Demand Embedded ML Functions
📚 Books worth reading
Database system conceptsAbraham Silberschatz · 1997
Learning PHP, MySQL & JavaScriptRobin Nixon · 2009- 📕PL/I programmer's guide to embedded SQL for DB2Jonathan S. Sayles · 1991
SQL, the complete referencePaul N. Weinberg · 2009
Intelligent Science and Intelligent Data EngineeringJian Yang · 2013
Embedded SQL for DB2Jonathan Sayles · 1990
Embedded SQL for DB2Jonathan S. Sayles · 1993- 📕INGRES embedded SQL companion guide for C · 1988
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Module SQL Module SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Module SQL statements…
- ECPG ECPG is the standard, in the PostgreSQL database built-in, client programming interface for embedding SQL in programs written in the C programming language…
- Comparison of relational database management systems The following tables compare general and technical information for a number of relational database management systems. Please see the individual products'…
- Perl DBI In computing, the Perl DBI (Perl Database Interface) offers a standardized way for programmers using the Perl programming language to embed database communicati…
- Information schema In relational databases, the information schema (information_schema) is an ANSI-standard set of read-only views that provide information about all of the…
- Mimer SQL Mimer SQL is a proprietary SQL-based relational database management system produced by the Swedish company Mimer Information Technology AB (Mimer AB),…
- Hierarchical and recursive queries in SQL A hierarchical query is a type of SQL query that handles hierarchical model data. These are useful for working with databases of graph-structured data…
- SQL:2011 SQL:2011 or ISO/IEC 9075:2011 (under the general title "Information technology – Database languages – SQL") is the seventh revision of the ISO (1987) and…