# Python SQLite API
# sqlite3 ó DB-API 2.0 interface for SQLite databases
# SQLite is a C library that provides a lightweight disk-based database that doesnít require a separate server process and allows
# accessing the database using a nonstandard variant of the SQL query language.
# Some applications can use SQLite for internal data storage.
# Itís also possible to prototype an application using SQLite and then port the code to a larger database such as PostgreSQL or Oracle.
# The sqlite3 module provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249.
# backup(target, *, pages=0, progress=None, name="main", sleep=0.250) 
# This method makes a backup of a SQLite database even while itís being accessed by other clients, or concurrently by the same connection.
# The copy will be written into the mandatory argument target, that must be another Connection instance.

#

# copy an existing database into a transient copy:
# 

import sqlite3

source = sqlite3.connect('existing_db.db')

dest = sqlite3.connect(':memory:')

source.backup(dest)
