René's URL Explorer Experiment

{"@context":"https://schema.org","@graph":[{"@type":"Article","@id":"https://pynative.com/python-sqlite/#article","isPartOf":{"@id":"https://pynative.com/python-sqlite/"},"author":{"name":"Vishal","@id":"https://pynative.com/#/schema/person/64b55d5bde2265918c5a9931de4de71f"},"headline":"Python SQLite tutorial using sqlite3","datePublished":"2019-06-24T18:52:58+00:00","dateModified":"2021-03-09T05:27:48+00:00","mainEntityOfPage":{"@id":"https://pynative.com/python-sqlite/"},"wordCount":2140,"commentCount":22,"publisher":{"@id":"https://pynative.com/#/schema/person/64b55d5bde2265918c5a9931de4de71f"},"image":{"@id":"https://pynative.com/python-sqlite/#primaryimage"},"thumbnailUrl":"https://pynative.com/wp-content/uploads/2019/06/python-sqlite.png","keywords":["Python SQLite"],"articleSection":["Python","Python Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https://pynative.com/python-sqlite/#respond"]}],"accessibilityFeature":["tableOfContents"]},{"@type":"WebPage","@id":"https://pynative.com/python-sqlite/","url":"https://pynative.com/python-sqlite/","name":"Python SQLite Using sqlite3 module","isPartOf":{"@id":"https://pynative.com/#website"},"primaryImageOfPage":{"@id":"https://pynative.com/python-sqlite/#primaryimage"},"image":{"@id":"https://pynative.com/python-sqlite/#primaryimage"},"thumbnailUrl":"https://pynative.com/wp-content/uploads/2019/06/python-sqlite.png","datePublished":"2019-06-24T18:52:58+00:00","dateModified":"2021-03-09T05:27:48+00:00","description":"Develop Python applications with SQLite database. Using sqlite3 module to access the SQLite database, perform SQLite data insertion, data retrieval, data update and data deletion, transaction management.","breadcrumb":{"@id":"https://pynative.com/python-sqlite/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https://pynative.com/python-sqlite/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https://pynative.com/python-sqlite/#primaryimage","url":"https://pynative.com/wp-content/uploads/2019/06/python-sqlite.png","contentUrl":"https://pynative.com/wp-content/uploads/2019/06/python-sqlite.png","width":441,"height":351,"caption":"Python SQLite"},{"@type":"BreadcrumbList","@id":"https://pynative.com/python-sqlite/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://pynative.com/"},{"@type":"ListItem","position":2,"name":"Python","item":"https://pynative.com/python/"},{"@type":"ListItem","position":3,"name":"Databases","item":"https://pynative.com/python/databases/"},{"@type":"ListItem","position":4,"name":"Python SQLite tutorial using sqlite3"}]},{"@type":"WebSite","@id":"https://pynative.com/#website","url":"https://pynative.com/","name":"PYnative","description":"Python Programming","publisher":{"@id":"https://pynative.com/#/schema/person/64b55d5bde2265918c5a9931de4de71f"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://pynative.com/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https://pynative.com/#/schema/person/64b55d5bde2265918c5a9931de4de71f","name":"Vishal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https://pynative.com/#/schema/person/image/","url":"https://pynative.com/wp-content/uploads/2019/01/vishalHule.jpg","contentUrl":"https://pynative.com/wp-content/uploads/2019/01/vishalHule.jpg","width":968,"height":1065,"caption":"Vishal"},"logo":{"@id":"https://pynative.com/#/schema/person/image/"},"description":"Founder of PYnative.com. I am a Python developer and I love to write articles to help developers. | All the best for your future Python endeavors!","sameAs":["https://pynative.com"]},{"@type":"HowTo","@id":"https://pynative.com/python-sqlite/#howto-1","name":"Python SQLite tutorial using sqlite3","mainEntityOfPage":{"@id":"https://pynative.com/python-sqlite/#article"},"description":"How to Connect to SQLite Database in Python","step":[{"@type":"HowToStep","url":"https://pynative.com/python-sqlite/#how-to-step-1612938393338","name":"Import sqlite3 module","itemListElement":[{"@type":"HowToDirection","text":"import sqlite3 statement imports the sqlite3 module in the program. Using the classes and methods defined in the sqlite3 module we can communicate with the SQLite database."}]},{"@type":"HowToStep","url":"https://pynative.com/python-sqlite/#how-to-step-1612938566138","name":"Use the connect() method","itemListElement":[{"@type":"HowToDirection","text":"Use the connect() method of the connector class with the database name. To establish a connection to SQLite, you need to pass the database name you want to connect. If you specify the database file name that already presents on the disk, it will connect to it. But if your specified SQLite database file doesn't exist, SQLite creates a new database for you.
This method returns the SQLite Connection Object if the connection is successful."}]},{"@type":"HowToStep","url":"https://pynative.com/python-sqlite/#how-to-step-1612939866983","name":"Use the cursor() method","itemListElement":[{"@type":"HowToDirection","text":"Use the cursor() method of a connection class to create a cursor object to execute SQLite command/queries from Python."}]},{"@type":"HowToStep","url":"https://pynative.com/python-sqlite/#how-to-step-1612938641024","name":"Use the execute() method","itemListElement":[{"@type":"HowToDirection","text":"The execute() methods run the SQL query and return the result."}]},{"@type":"HowToStep","url":"https://pynative.com/python-sqlite/#how-to-step-1612938710846","name":"Extract result using fetchall()","itemListElement":[{"@type":"HowToDirection","text":"Use cursor.fetchall() or fetchone() or fetchmany() to read query result."}]},{"@type":"HowToStep","url":"https://pynative.com/python-sqlite/#how-to-step-1612938784560","name":"Close cursor and connection objects","itemListElement":[{"@type":"HowToDirection","text":"use cursor.clsoe() and connection.clsoe() method to close the cursor and SQLite connections after your work completes"}]},{"@type":"HowToStep","url":"https://pynative.com/python-sqlite/#how-to-step-1614102197674","text":"Catch database exception if any that may occur during this connection process."}],"inLanguage":"en-US"}]}