{"id":8472,"date":"2024-03-22T18:35:46","date_gmt":"2024-03-22T13:05:46","guid":{"rendered":"https:\/\/btechgeeks.com\/?p=8472"},"modified":"2024-03-23T11:14:56","modified_gmt":"2024-03-23T05:44:56","slug":"python-data-persistence-rdbms-products","status":"publish","type":"post","link":"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/","title":{"rendered":"Python Data Persistence &#8211; RDBMS Products"},"content":{"rendered":"<h2>Python Data Persistence &#8211; RDBMS Products<\/h2>\n<p>Relational Software Inc. (now Oracle Corp) developed its first SQL-based RDBMS software called Oracle V2. IBM introduced System-R as its RDBMS product in 1974 and followed it by a very successful DB2 product.<br \/>\nMicrosoft released SQL Server for Windows NT in 1994. Newer versions of MS SQL server are integrated with Microsoft\u2019s .NET Framework.<br \/>\nSAP is an enterprise-level RDBMS product targeted towards UNIX-based systems being marketed as Enterprise Resource Planning (ERP) products.<\/p>\n<p>An open-source RDBMS product named MySQL, developed by a Swedish company MySQL AB was later acquired by Sun Microsystems, which in turn has, now, been acquired by Oracle Corporation. Being an open-source product, MySQL is a highly popular choice, after Oracle.<br \/>\nMS Access, shipped with the Microsoft Office suite, is widely used in small-scale projects. The entire database is stored in a single file and, hence, is easily portable. It provides excellent GUI tools to design tables, queries, forms, and reports.<\/p>\n<p>PostgreSQL is also an open-source object-oriented RDBMS, which has evolved from the Ingres project of the University of California, Berkley. It is available for use on diverse operating system platforms and SQL implementation is supposed to be closest to SQL standard.<br \/>\nSQLite is a very popular relational database used in a wide variety of applications. Unlike other databases like Oracle, MySQL, etc., SQLite is a transactional SQL database engine that is self-contained and serverless. As its official documentation describes, it is a self-contained, serverless, zero-configuration, transactional SQL database engine. The entire database is a single file that can be placed anywhere in the file system.<\/p>\n<ul>\n<li><a href=\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-concepts\/\">Python Data Persistence &#8211; RDBMS Concepts<\/a><\/li>\n<li><a href=\"https:\/\/btechgeeks.com\/python-data-persistence-python-cassandra\/\">Python Data Persistence &#8211; Python &#8211; Cassandra<\/a><\/li>\n<li><a href=\"https:\/\/btechgeeks.com\/data-persistence-python-pymongo\/\">Data Persistence &#8211; Python &#8211; PyMongo<\/a><\/li>\n<\/ul>\n<p>SQLite was developed by D. Richard Hipp in 2000. Its current version is 3.27.2. It is fully ACID compliant which ensures that transactions are atomic, consistent, isolated, and durable.<br \/>\nBecause of its open-source nature, very small footprint, and zero-configuration, SQLite databases are popularly used in embedded devices, IoT, and mobile apps. Many web browsers and operating systems also use SQLite database for internal use. It is also used as prototyping and demo of larger enterprise RDBMS.<\/p>\n<p>Despite being very lightweight, it is a full-featured SQL implementation with all the advanced capabilities. SQLite database can be interfaced with most of the mainstream languages like C\/C++, Java, PHP, etc. Python\u2019s standard library contains the sqlite3 module. It provides all the functionality for interfacing the Python program with the SQLite database.<\/p>\n<p>7.4 SQLite installation<\/p>\n<p>Installation of SQLite is simple and straightforward. It doesn\u2019t need any elaborate installation. The entire application is a self-contained executable \u2018sqlite3.exe\u2019. Official website of SQLite, (https:\/\/sqIite.org\/download.html) provides pre-compiled binaries for various operating system platforms containing the command line shell bundled with other utilities. All you have to do is download a zip&#8217;archive of SQLite command-line tools, unzip to a suitable location and invoke sqlite3.exe from DOS prompt by putting name of the database you want to open.<br \/>\nIf already existing, the SqLite3 database engine will connect to it; otherwise, a new database will be created. If the name is omitted, an in memory transient database will open. Let us ask SQLite to open a new<br \/>\nmydatabase.sqlite3.<\/p>\n<p>E:\\SQLite&gt;sqlite3 mydatabase.sqlite3<br \/>\nSQLite version 3.25.1 2018-09-18 20:20:44<br \/>\nEnter &#8220;.help&#8221; for usage hints.<br \/>\nsqlite&gt;<\/p>\n<p>In the command window a sqlite prompt appears before which any SQL query can be executed. In addition, there \u201cdot commands\u201d (beginning with a dot \u201c.\u201d) typically used to change the output format of queries, or to execute certain prepackaged query statements.<br \/>\nAn existing database can also be opened using .open command.<\/p>\n<p>E:\\SQLite&gt;sqlite3<br \/>\nSQLite version 3.25.1 2018-09-18 20:20:44<br \/>\nEnter &#8220;.help&#8221; for usage hints.<br \/>\nConnected to a transient in-memory database.<br \/>\nUse &#8220;.open FILENAME&#8221; to reopen on a persistent database.<br \/>\nsqlite&gt; .open test.db<\/p>\n<p>The first step is to create a table in the database. As mentioned above, we need to define its structure specifying name of the column and its data type.<\/p>\n<p>SQUte Data Types<\/p>\n<p>ANSI SQL defines generic data types, which are implemented by various RDBMS products with a few variations on their own. Most of the SQL database engines (Oracle, MySQL, SQL Server, etc.) use static typing. SQLite, on the other hand, uses a more general dynamic type system. Each value stored inSQLite database (or manipulated by the database engine) has one of the following storage classes:<br \/>\n\u2022 NULL<br \/>\n\u2022 INTEGER<br \/>\n\u2022 REAL &#8216;<br \/>\n\u2022 TEXT<br \/>\n\u2022 BLOB<br \/>\nA storage class is more general than a datatype. These storage classes are mapped to standard SQL data types. For example, INTEGER in SQLite has a type affinity with all integer types such as int, smallint, bigint, tinyint, etc. Similarly REAL in SQLite has a type affinity with float and double data type. Standard SQL data types such as varchar, char,nchar, etc. are equivalent to TEXT in SQLite.<br \/>\nSQL as a language consists of many declarative statements that perform various operations on databases and tables. These statements are popularly called queries. CREATE TABLE query defines table structure using the above data types.<\/p>\n<p>CREATE TABLE<\/p>\n<p>This statement is used to create a new table, specifying following details:<br \/>\n\u2022 Name of new table<br \/>\n\u2022 Names of columns (fields) in the desired table<br \/>\n\u2022 Type, width, and the default value of each column.<br \/>\n\u2022 Optional constraints on columns (PRIMARY KEY, NOT NULL, FOREIGN KEY)<\/p>\n<p>Example<\/p>\n<p>CREATE TABLE table_name (<br \/>\ncolumn 1 datatype [width] [default] [constraint],<br \/>\ncolumn2 ,<br \/>\ncolumn3 &#8230;,<br \/>\n) ;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Python Data Persistence &#8211; RDBMS Products Relational Software Inc. (now Oracle Corp) developed its first SQL-based RDBMS software called Oracle V2. IBM introduced System-R as its RDBMS product in 1974 and followed it by a very successful DB2 product. Microsoft released SQL Server for Windows NT in 1994. Newer versions of MS SQL server are &#8230; <a title=\"Python Data Persistence &#8211; RDBMS Products\" class=\"read-more\" href=\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/\" aria-label=\"More on Python Data Persistence &#8211; RDBMS Products\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":""},"categories":[5],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Python Data Persistence - RDBMS Products - BTech Geeks<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python Data Persistence - RDBMS Products - BTech Geeks\" \/>\n<meta property=\"og:description\" content=\"Python Data Persistence &#8211; RDBMS Products Relational Software Inc. (now Oracle Corp) developed its first SQL-based RDBMS software called Oracle V2. IBM introduced System-R as its RDBMS product in 1974 and followed it by a very successful DB2 product. Microsoft released SQL Server for Windows NT in 1994. Newer versions of MS SQL server are ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/\" \/>\n<meta property=\"og:site_name\" content=\"BTech Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/btechgeeks\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-22T13:05:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-23T05:44:56+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@btech_geeks\" \/>\n<meta name=\"twitter:site\" content=\"@btech_geeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prasanna\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/btechgeeks.com\/#organization\",\"name\":\"BTech Geeks\",\"url\":\"https:\/\/btechgeeks.com\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/btechgeeks\",\"https:\/\/www.instagram.com\/btechgeeks\/\",\"https:\/\/www.linkedin.com\/in\/btechgeeks\",\"https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg\",\"https:\/\/in.pinterest.com\/btechgeek\/\",\"https:\/\/twitter.com\/btech_geeks\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/btechgeeks.com\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"contentUrl\":\"https:\/\/btechgeeks.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"width\":350,\"height\":70,\"caption\":\"BTech Geeks\"},\"image\":{\"@id\":\"https:\/\/btechgeeks.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/btechgeeks.com\/#website\",\"url\":\"https:\/\/btechgeeks.com\/\",\"name\":\"BTech Geeks\",\"description\":\"Lecture Notes for BTech, BSc Students\",\"publisher\":{\"@id\":\"https:\/\/btechgeeks.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/btechgeeks.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#webpage\",\"url\":\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/\",\"name\":\"Python Data Persistence - RDBMS Products - BTech Geeks\",\"isPartOf\":{\"@id\":\"https:\/\/btechgeeks.com\/#website\"},\"datePublished\":\"2024-03-22T13:05:46+00:00\",\"dateModified\":\"2024-03-23T05:44:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/btechgeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python Data Persistence &#8211; RDBMS Products\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#webpage\"},\"author\":{\"@id\":\"https:\/\/btechgeeks.com\/#\/schema\/person\/ea8ce699662f0d7e248e52fe080b85bb\"},\"headline\":\"Python Data Persistence &#8211; RDBMS Products\",\"datePublished\":\"2024-03-22T13:05:46+00:00\",\"dateModified\":\"2024-03-23T05:44:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#webpage\"},\"wordCount\":905,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/btechgeeks.com\/#organization\"},\"articleSection\":[\"Python\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/btechgeeks.com\/#\/schema\/person\/ea8ce699662f0d7e248e52fe080b85bb\",\"name\":\"Prasanna\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/btechgeeks.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/174540ad43736c7d1a4c4f83c775e74d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/174540ad43736c7d1a4c4f83c775e74d?s=96&d=mm&r=g\",\"caption\":\"Prasanna\"},\"url\":\"https:\/\/btechgeeks.com\/author\/prasanna\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Python Data Persistence - RDBMS Products - BTech Geeks","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/","og_locale":"en_US","og_type":"article","og_title":"Python Data Persistence - RDBMS Products - BTech Geeks","og_description":"Python Data Persistence &#8211; RDBMS Products Relational Software Inc. (now Oracle Corp) developed its first SQL-based RDBMS software called Oracle V2. IBM introduced System-R as its RDBMS product in 1974 and followed it by a very successful DB2 product. Microsoft released SQL Server for Windows NT in 1994. Newer versions of MS SQL server are ... Read more","og_url":"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/","og_site_name":"BTech Geeks","article_publisher":"https:\/\/www.facebook.com\/btechgeeks","article_published_time":"2024-03-22T13:05:46+00:00","article_modified_time":"2024-03-23T05:44:56+00:00","twitter_card":"summary_large_image","twitter_creator":"@btech_geeks","twitter_site":"@btech_geeks","twitter_misc":{"Written by":"Prasanna","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/btechgeeks.com\/#organization","name":"BTech Geeks","url":"https:\/\/btechgeeks.com\/","sameAs":["https:\/\/www.facebook.com\/btechgeeks","https:\/\/www.instagram.com\/btechgeeks\/","https:\/\/www.linkedin.com\/in\/btechgeeks","https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg","https:\/\/in.pinterest.com\/btechgeek\/","https:\/\/twitter.com\/btech_geeks"],"logo":{"@type":"ImageObject","@id":"https:\/\/btechgeeks.com\/#logo","inLanguage":"en-US","url":"https:\/\/btechgeeks.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","contentUrl":"https:\/\/btechgeeks.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","width":350,"height":70,"caption":"BTech Geeks"},"image":{"@id":"https:\/\/btechgeeks.com\/#logo"}},{"@type":"WebSite","@id":"https:\/\/btechgeeks.com\/#website","url":"https:\/\/btechgeeks.com\/","name":"BTech Geeks","description":"Lecture Notes for BTech, BSc Students","publisher":{"@id":"https:\/\/btechgeeks.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/btechgeeks.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#webpage","url":"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/","name":"Python Data Persistence - RDBMS Products - BTech Geeks","isPartOf":{"@id":"https:\/\/btechgeeks.com\/#website"},"datePublished":"2024-03-22T13:05:46+00:00","dateModified":"2024-03-23T05:44:56+00:00","breadcrumb":{"@id":"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/btechgeeks.com\/"},{"@type":"ListItem","position":2,"name":"Python Data Persistence &#8211; RDBMS Products"}]},{"@type":"Article","@id":"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#article","isPartOf":{"@id":"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#webpage"},"author":{"@id":"https:\/\/btechgeeks.com\/#\/schema\/person\/ea8ce699662f0d7e248e52fe080b85bb"},"headline":"Python Data Persistence &#8211; RDBMS Products","datePublished":"2024-03-22T13:05:46+00:00","dateModified":"2024-03-23T05:44:56+00:00","mainEntityOfPage":{"@id":"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#webpage"},"wordCount":905,"commentCount":0,"publisher":{"@id":"https:\/\/btechgeeks.com\/#organization"},"articleSection":["Python"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/btechgeeks.com\/python-data-persistence-rdbms-products\/#respond"]}]},{"@type":"Person","@id":"https:\/\/btechgeeks.com\/#\/schema\/person\/ea8ce699662f0d7e248e52fe080b85bb","name":"Prasanna","image":{"@type":"ImageObject","@id":"https:\/\/btechgeeks.com\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/174540ad43736c7d1a4c4f83c775e74d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/174540ad43736c7d1a4c4f83c775e74d?s=96&d=mm&r=g","caption":"Prasanna"},"url":"https:\/\/btechgeeks.com\/author\/prasanna\/"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":8525,"url":"https:\/\/btechgeeks.com\/python-data-persistence-mysql\/","url_meta":{"origin":8472,"position":0},"title":"Python Data Persistence - MySQL","date":"March 27, 2024","format":false,"excerpt":"Python Data Persistence - MySQL So far we have learned how some basic SQL operations are performed over a relational database using SQLite console. Similar console-driven interaction is possible with other RDBMS products. MySQL console works more or less similar (barring certain syntactical differences) to the SQLite console we've used\u2026","rel":"","context":"In &quot;Python&quot;","img":{"alt_text":"Python Data Presistence - MySQL chapter 7 img 1","src":"https:\/\/i0.wp.com\/btechgeeks.com\/wp-content\/uploads\/2021\/06\/Python-Data-Presistence-MySQL-chapter-7-img-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":8579,"url":"https:\/\/btechgeeks.com\/python-data-persistence-pyodbc-module\/","url_meta":{"origin":8472,"position":1},"title":"Python Data Persistence - pyodbc Module","date":"March 26, 2024","format":false,"excerpt":"Python Data Persistence - pyodbc Module ODBC is a language and operating system independent API for accessing relational databases. The product module enables access to any RDBMS for which the respective ODBC driver is available on the operating system. Most of the established relational database products (Oracle, MySQL, PostgreSQL, SQL\u2026","rel":"","context":"In &quot;Python&quot;","img":{"alt_text":"Python Data Presistence - pyodbc Module chapter 8 img 1","src":"https:\/\/i0.wp.com\/btechgeeks.com\/wp-content\/uploads\/2021\/06\/Python-Data-Presistence-pyodbc-Module-chapter-8-img-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":8469,"url":"https:\/\/btechgeeks.com\/python-data-persistence-relational-database\/","url_meta":{"origin":8472,"position":2},"title":"Python Data Persistence - Relational Database","date":"March 22, 2024","format":false,"excerpt":"Python Data Persistence - Relational Database The term \u2018database\u2019 refers to an organized collection of data so as to remove redundancy and inconsistency, and to ensure data integrity. Over the years, different database models have been in use. The early days of computing observed the use of hierarchical and network\u2026","rel":"","context":"In &quot;Python&quot;","img":{"alt_text":"Python Data Presistence - Relational Database chapter 7 img 1","src":"https:\/\/i0.wp.com\/btechgeeks.com\/wp-content\/uploads\/2021\/06\/Python-Data-Presistence-Relational-Database-chapter-7-img-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":8537,"url":"https:\/\/btechgeeks.com\/data-persistence-python-database-dbapi\/","url_meta":{"origin":8472,"position":3},"title":"Data Persistence Python Database DBAPI","date":"March 29, 2024","format":false,"excerpt":"Python Data Persistence - Python DB-API The previous chapter was an overview of SQL fundamentals with the help of the SQLite database. However, as mentioned therein short, there are several equally popular RDBMS in use worldwide. Some of them are open-source and others for enterprise use. Although all of them\u2026","rel":"","context":"In &quot;Python&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9022,"url":"https:\/\/btechgeeks.com\/python-data-persistence-python-cassandra\/","url_meta":{"origin":8472,"position":4},"title":"Python Data Persistence - Python - Cassandra","date":"March 21, 2024","format":false,"excerpt":"Python Data Persistence - Python - Cassandra In this last chapter, we are going to deal with another important NOSQL database - Cassandra. Today some of the biggest IT giants (including FaceBook, Twitter, Cisco, and so on) use Cassandra because of its high scalability, consistency, and fault-tolerance. Cassandra is a\u2026","rel":"","context":"In &quot;Python&quot;","img":{"alt_text":"Python Data Presistence - Python - Cassandra chapter 12 img 3","src":"https:\/\/i0.wp.com\/btechgeeks.com\/wp-content\/uploads\/2021\/06\/Python-Data-Presistence-Python-Cassandra-chapter-12-img-3.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":8467,"url":"https:\/\/btechgeeks.com\/python-data-persistence-rdbms-concepts\/","url_meta":{"origin":8472,"position":5},"title":"Python Data Persistence - RDBMS Concepts","date":"March 21, 2024","format":false,"excerpt":"Python Data Persistence - RDBMS Concepts The previous chapter discussed various tools offered by Python for data persistence. While the built-in file object can perform basic read\/write operations with a disk file, other built-in modules such as pickle and shelve enable storage and retrieval of serialized data to\/from disk files.\u2026","rel":"","context":"In &quot;Python&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/posts\/8472"}],"collection":[{"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/comments?post=8472"}],"version-history":[{"count":1,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/posts\/8472\/revisions"}],"predecessor-version":[{"id":34850,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/posts\/8472\/revisions\/34850"}],"wp:attachment":[{"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/media?parent=8472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/categories?post=8472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/btechgeeks.com\/wp-json\/wp\/v2\/tags?post=8472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}