RemoteSqlite
No description available
Install / Use
/learn @vbalasu/RemoteSqliteREADME
<div id="notebook" class="border-box-sizing" tabindex="-1">
<div id="notebook-container" class="container">
<div class="cell border-box-sizing text_cell rendered">
<div class="prompt input_prompt">
</div>
<div class="inner_cell">
<div class="text_cell_render border-box-sizing rendered_html">
RemoteSqlite
</div> </div> </div> <div class="cell border-box-sizing text_cell rendered"> <div class="prompt input_prompt"> </div> <div class="inner_cell"> <div class="text_cell_render border-box-sizing rendered_html">RemoteSqlite is a way to easily access a remote Sqlite database and perform queries, including SELECT and INSERT operations
The remote database is referenced through a PyFilesystem2 url, such as:
osfs://path/to/files3://path/to/file
You can perform pull and push operations that transfer the database
to a local temp directory
See below for examples of how to use
</div> </div> </div> <div class="cell border-box-sizing code_cell rendered"> <div class="input"> <div class="prompt input_prompt">In [1]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">from remote_sqlite import RemoteSqlite
db = RemoteSqlite('osfs:///Users/vbalasubramaniam/Downloads/Northwind_large.sqlite', always_download=True)
db.get_counts()
Out[1]:
</div> <div class="output_text output_subarea output_execute_result">[{'Employee': 9},
{'Category': 8},
{'Customer': 91},
{'Shipper': 3},
{'Supplier': 29},
{'Order': 16818},
{'Product': 77},
{'OrderDetail': 621883},
{'CustomerCustomerDemo': 0},
{'CustomerDemographic': 0},
{'Region': 4},
{'Territory': 53},
{'EmployeeTerritory': 49},
{'posts': 0},
{'posts_data': 2},
{'posts_idx': 0},
{'posts_content': 0},
{'posts_docsize': 0},
{'posts_config': 1},
{'order_search': 16818},
{'order_search_data': 226},
{'order_search_idx': 474},
{'order_search_content': 16818},
{'order_search_docsize': 16818},
{'order_search_config': 1}]
In [2]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">db.select("""SELECT * FROM Shipper""")
Out[2]:
</div> <div class="output_text output_subarea output_execute_result">[{'Id': 1, 'CompanyName': 'Speedy Express', 'Phone': '(503) 555-9831'},
{'Id': 2, 'CompanyName': 'United Package', 'Phone': '(503) 555-3199'},
{'Id': 3, 'CompanyName': 'Federal Shipping', 'Phone': '(503) 555-9931'}]
In [3]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">new_records = [{'Id': 4, 'CompanyName': 'Speedy Express', 'Phone': '(503) 555-9831'},
{'Id': 5, 'CompanyName': 'United Package', 'Phone': '(503) 555-3199'},
{'Id': 6, 'CompanyName': 'Federal Shipping', 'Phone': '(503) 555-9931'}]
In [4]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">db.insert('Shipper', new_records)
In [5]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">db.con.execute('DELETE FROM Shipper WHERE Id >3')
Out[5]:
</div> <div class="output_text output_subarea output_execute_result"><sqlite3.Cursor at 0x10535bab0>
In [6]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">create_statement = """CREATE TABLE test (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
t TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)"""
In [7]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">db.con.execute(create_statement)
Out[7]:
</div> <div class="output_text output_subarea output_execute_result"><sqlite3.Cursor at 0x1053a43b0>
In [8]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">db.insert('test', [{'name': 'John'},{'name':'Matt'}])
In [9]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">db.select('SELECT * FROM test')
Out[9]:
</div> <div class="output_text output_subarea output_execute_result">[{'id': 1, 'name': 'John', 't': datetime.datetime(2020, 3, 7, 22, 12, 45)},
{'id': 2, 'name': 'Matt', 't': datetime.datetime(2020, 3, 7, 22, 12, 45)}]
In [10]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">db.con.execute('DROP TABLE test')
Out[10]:
</div> <div class="output_text output_subarea output_execute_result"><sqlite3.Cursor at 0x1053a42d0>
In [11]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">db.generate_create_table('Shipper2', [{'Id': 1, 'CompanyName': 'Speedy Express', 'Phone': '(503) 555-9831'},
{'Id': 2, 'CompanyName': 'United Package', 'Phone': '(503) 555-3199'},
{'Id': 3, 'CompanyName': 'Federal Shipping', 'Phone': '(503) 555-9931'}])
Out[11]:
</div> <div class="output_text output_subarea output_execute_result">'CREATE TABLE "Shipper2" ("Id" TEXT, "CompanyName" TEXT, "Phone" TEXT)'
In [12]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">db.con.execute('CREATE TABLE "Shipper2" ("Id" TEXT, "CompanyName" TEXT, "Phone" TEXT)')
Out[12]:
</div> <div class="output_text output_subarea output_execute_result"><sqlite3.Cursor at 0x1053a4340>
In [13]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">db.insert('Shipper2', [{'Id': 1, 'CompanyName': 'Speedy Express', 'Phone': '(503) 555-9831'},
{'Id': 2, 'CompanyName': 'United Package', 'Phone': '(503) 555-3199'},
{'Id': 3, 'CompanyName': 'Federal Shipping', 'Phone': '(503) 555-9931'}])
In [14]:
</div> <div class="inner_cell"> <div class="input_area"> <div class="highlight hl-ipython3">db.select('SELECT * FROM Shipper2')
Out[14]:
</div> <div class="output_text output_subarea output_execute_result">[{'Id': '1', 'CompanyName': 'Speedy Express', 'Phone': '(503) 555-9831'},
{'Id': '2', 'CompanyName': 'United Package', 'Phone': '(503) 555-3199'},
{'Id': '3', 'CompanyName': 'Federal Shipping', 'Phone': '(503) 555-9931'}]
In [ ]:
</div> <div class="inner_cell">Related Skills
feishu-drive
339.5k|
things-mac
339.5kManage Things 3 via the `things` CLI on macOS (add/update projects+todos via URL scheme; read/search/list from the local Things database)
clawhub
339.5kUse the ClawHub CLI to search, install, update, and publish agent skills from clawhub.com
yu-ai-agent
2.0k编程导航 2025 年 AI 开发实战新项目，基于 Spring Boot 3 + Java 21 + Spring AI 构建 AI 恋爱大师应用和 ReAct 模式自主规划智能体YuManus，覆盖 AI 大模型接入、Spring AI 核心特性、Prompt 工程和优化、RAG 检索增强、向量数据库、Tool Calling 工具调用、MCP 模型上下文协议、AI Agent 开发（Manas Java 实现）、Cursor AI 工具等核心知识。用一套教程将程序员必知必会的 AI 技术一网打尽，帮你成为 AI 时代企业的香饽饽，给你的简历和求职大幅增加竞争力。
