René's URL Explorer Experiment


Title: SQLite | Skip

Open Graph Title: SQLite

Description: Documentation for SQLite fetched from GitHub.

Open Graph Description: Documentation for SQLite fetched from GitHub.

Opengraph URL: https://skip.dev/docs/modules/skip-sql/

X: @skiptools

Generator: Starlight v0.39.2

direct link

Domain: skip.dev

og:localeen
twitter:cardsummary_large_image
og:site_nameSkip
og:typewebsite
og:imagehttps://skip.dev/og/docs/modules/skip-sql.png
og:image:width1200
og:image:height630
og:image:typeimage/png
twitter:imagehttps://skip.dev/og/docs/modules/skip-sql.png

Links:

Skip to contenthttps://skip.dev/docs/modules/skip-sql/#_top
Skip https://skip.dev/
Documentation https://skip.dev/docs/
Gallery https://skip.dev/gallery/
Blog https://skip.dev/blog/
Sponsor https://skip.dev/sponsor/
3.1k https://github.com/skiptools/skip
Forumshttps://forums.skip.dev
Slackhttps://skip.dev/slack/
Mastodonhttps://mas.to/@skiptools
Twitterhttps://x.com/skiptools
GitHubhttps://github.com/orgs/skiptools
RSShttps://skip.dev/blog/rss.xml
Blog https://skip.dev/blog/
What is Skip? https://skip.dev/docs/
Getting Started https://skip.dev/docs/gettingstarted/
Project Structure https://skip.dev/docs/project-types/
Lite and Fuse Modes https://skip.dev/docs/modes/
App Development https://skip.dev/docs/app-development/
Common Topics https://skip.dev/docs/development-topics/
Cross-Platform Topics https://skip.dev/docs/platformcustomization/
Debugging https://skip.dev/docs/debugging/
Testing https://skip.dev/docs/testing/
Dependencies https://skip.dev/docs/dependencies/
Deployment https://skip.dev/docs/deployment/
Bridging Reference https://skip.dev/docs/bridging/
Transpilation Reference https://skip.dev/docs/swiftsupport/
Gradle Project Reference https://skip.dev/docs/gradle/
Porting Swift Packages to Android https://skip.dev/docs/porting/
Contributing https://skip.dev/docs/contributing/
Skip CLI Reference https://skip.dev/docs/skip-cli/
C Development Reference https://skip.dev/docs/c-development/
Update Guide https://skip.dev/docs/update-guide/
Internal Architecture https://skip.dev/docs/architecture/
Getting Help https://skip.dev/docs/help/
FAQs https://skip.dev/docs/faq/
Framework Comparisons https://skip.dev/compare/
Glossary https://skip.dev/docs/glossary/
Release Notes https://skip.dev/releases/
SkipUnit https://skip.dev/docs/modules/skip-unit/
SkipLib https://skip.dev/docs/modules/skip-lib/
SkipFoundation https://skip.dev/docs/modules/skip-foundation/
SkipModel https://skip.dev/docs/modules/skip-model/
SkipUI https://skip.dev/docs/modules/skip-ui/
SkipFuse https://skip.dev/docs/modules/skip-fuse/
SkipFuseUI https://skip.dev/docs/modules/skip-fuse-ui/
SkipBridge https://skip.dev/docs/modules/skip-bridge/
App Support https://skip.dev/docs/modules/skip-kit/
Audio/Video https://skip.dev/docs/modules/skip-av/
Authentication https://skip.dev/docs/modules/skip-authentication-services/
Bluetooth https://skip.dev/docs/modules/skip-bluetooth/
Calendar https://skip.dev/docs/modules/skip-calendar/
Contacts https://skip.dev/docs/modules/skip-contacts/
FFI https://skip.dev/docs/modules/skip-ffi/
JavaScriptCore https://skip.dev/docs/modules/skip-script/
Keychain https://skip.dev/docs/modules/skip-keychain/
NFC https://skip.dev/docs/modules/skip-nfc/
Push Notifications https://skip.dev/docs/modules/skip-notify/
QR Codes https://skip.dev/docs/modules/skip-qrcode/
Sensors https://skip.dev/docs/modules/skip-device/
SQLite https://skip.dev/docs/modules/skip-sql/
WebView https://skip.dev/docs/modules/skip-web/
XML https://skip.dev/docs/modules/skip-xml/
Zip https://skip.dev/docs/modules/skip-zip/
Auth0 https://skip.dev/docs/modules/skip-auth0/
Firebase https://skip.dev/docs/modules/skip-firebase/
WebRTC (LiveKit) https://skip.dev/docs/modules/skip-livekit/
Marketplace https://skip.dev/docs/modules/skip-marketplace/
Lottie https://skip.dev/docs/modules/skip-motion/
PostHog https://skip.dev/docs/modules/skip-posthog/
RevenueCat https://skip.dev/docs/modules/skip-revenue/
Sentry https://skip.dev/docs/modules/skip-sentry/
Socket.IO https://skip.dev/docs/modules/skip-socketio/
Supabase https://skip.dev/docs/modules/skip-supabase/
Showcase https://skip.dev/docs/samples/skipapp-showcase/
Hello Skip (Lite) https://skip.dev/docs/samples/skipapp-hello/
Howdy Skip (Fuse) https://skip.dev/docs/samples/skipapp-howdy/
Ahoy Skipper (Split Fuse) https://skip.dev/docs/samples/skipapp-ahoy/
Hiya Skip (Split Mixed) https://skip.dev/docs/samples/skipapp-hiya/
Travel Bookings (Fuse) https://skip.dev/docs/samples/skipapp-bookings-fuse/
Travel Bookings (Lite) https://skip.dev/docs/samples/skipapp-bookings/
Travel Posters (Split) https://skip.dev/docs/samples/skipapp-travelposters-native/
Fireside (Fuse) https://skip.dev/docs/samples/skipapp-fireside-fuse/
Fireside (Lite) https://skip.dev/docs/samples/skipapp-fireside/
Notes (Lite) https://skip.dev/docs/samples/skipapp-notes/
Data Bake (Lite) https://skip.dev/docs/samples/skipapp-databake/
Weather (Lite) https://skip.dev/docs/samples/skipapp-weather/
Lottie (Lite) https://skip.dev/docs/samples/skipapp-lottiedemo/
Scrumskipper (Lite) https://skip.dev/docs/samples/skipapp-scrumskipper/
SkipUI Component Samples https://skip.dev/docs/components/
Accessibility https://skip.dev/docs/components/accessibility/
Alert https://skip.dev/docs/components/alert/
Animation https://skip.dev/docs/components/animation/
Audio https://skip.dev/docs/components/audio/
Background https://skip.dev/docs/components/background/
Border https://skip.dev/docs/components/border/
Button https://skip.dev/docs/components/button/
Color https://skip.dev/docs/components/color/
ColorScheme https://skip.dev/docs/components/colorscheme/
ConfirmationDialog https://skip.dev/docs/components/confirmationdialog/
DatePicker https://skip.dev/docs/components/datepicker/
DisclosureGroup https://skip.dev/docs/components/disclosuregroup/
Divider https://skip.dev/docs/components/divider/
Form https://skip.dev/docs/components/form/
Frame https://skip.dev/docs/components/frame/
GeometryReader https://skip.dev/docs/components/geometryreader/
Gesture https://skip.dev/docs/components/gesture/
Gradient https://skip.dev/docs/components/gradient/
Grid https://skip.dev/docs/components/grid/
HapticFeedback https://skip.dev/docs/components/hapticfeedback/
Icon https://skip.dev/docs/components/icon/
Image https://skip.dev/docs/components/image/
Keyboard https://skip.dev/docs/components/keyboard/
Label https://skip.dev/docs/components/label/
Link https://skip.dev/docs/components/link/
List https://skip.dev/docs/components/list/
Localization https://skip.dev/docs/components/localization/
Menu https://skip.dev/docs/components/menu/
Modifier https://skip.dev/docs/components/modifier/
NavigationStack https://skip.dev/docs/components/navigationstack/
Observable https://skip.dev/docs/components/observable/
Offset https://skip.dev/docs/components/offset/
OffsetPosition https://skip.dev/docs/components/offsetposition/
OnSubmit https://skip.dev/docs/components/onsubmit/
Overlay https://skip.dev/docs/components/overlay/
Pasteboard https://skip.dev/docs/components/pasteboard/
Picker https://skip.dev/docs/components/picker/
ProgressView https://skip.dev/docs/components/progressview/
SafeArea https://skip.dev/docs/components/safearea/
ScenePhase https://skip.dev/docs/components/scenephase/
ScrollView https://skip.dev/docs/components/scrollview/
Searchable https://skip.dev/docs/components/searchable/
SecureField https://skip.dev/docs/components/securefield/
Shadow https://skip.dev/docs/components/shadow/
Shape https://skip.dev/docs/components/shape/
ShareLink https://skip.dev/docs/components/sharelink/
Sheet https://skip.dev/docs/components/sheet/
Slider https://skip.dev/docs/components/slider/
Spacer https://skip.dev/docs/components/spacer/
Stack https://skip.dev/docs/components/stack/
State https://skip.dev/docs/components/state/
Storage https://skip.dev/docs/components/storage/
Symbol https://skip.dev/docs/components/symbol/
Table https://skip.dev/docs/components/table/
TabView https://skip.dev/docs/components/tabview/
Text https://skip.dev/docs/components/text/
TextEditor https://skip.dev/docs/components/texteditor/
TextField https://skip.dev/docs/components/textfield/
Timer https://skip.dev/docs/components/timer/
Toggle https://skip.dev/docs/components/toggle/
Toolbar https://skip.dev/docs/components/toolbar/
Transition https://skip.dev/docs/components/transition/
VideoPlayer https://skip.dev/docs/components/videoplayer/
ZIndex https://skip.dev/docs/components/zindex/
Forumshttps://forums.skip.dev
Slackhttps://skip.dev/slack/
Mastodonhttps://mas.to/@skiptools
Twitterhttps://x.com/skiptools
GitHubhttps://github.com/orgs/skiptools
RSShttps://skip.dev/blog/rss.xml
Overview https://skip.dev/docs/modules/skip-sql/#_top
Usage https://skip.dev/docs/modules/skip-sql/#usage
Connection example https://skip.dev/docs/modules/skip-sql/#connection-example
In-memory databases https://skip.dev/docs/modules/skip-sql/#in-memory-databases
Transactions https://skip.dev/docs/modules/skip-sql/#transactions
Bound parameters https://skip.dev/docs/modules/skip-sql/#bound-parameters
Schema Migration https://skip.dev/docs/modules/skip-sql/#schema-migration
Concurrency https://skip.dev/docs/modules/skip-sql/#concurrency
SQLCodable https://skip.dev/docs/modules/skip-sql/#sqlcodable
Querying with SQLPredicate https://skip.dev/docs/modules/skip-sql/#querying-with-sqlpredicate
Convenience Query Methods https://skip.dev/docs/modules/skip-sql/#convenience-query-methods
Primary keys and auto-increment columns https://skip.dev/docs/modules/skip-sql/#primary-keys-and-auto-increment-columns
Date fields https://skip.dev/docs/modules/skip-sql/#date-fields
Relations and joins https://skip.dev/docs/modules/skip-sql/#relations-and-joins
Implementation https://skip.dev/docs/modules/skip-sql/#implementation
SQLite Versions https://skip.dev/docs/modules/skip-sql/#sqlite-versions
Vendored SQLite Versions https://skip.dev/docs/modules/skip-sql/#vendored-sqlite-versions
SQLPlus https://skip.dev/docs/modules/skip-sql/#sqlplus
Building https://skip.dev/docs/modules/skip-sql/#building
Testing https://skip.dev/docs/modules/skip-sql/#testing
Contributing https://skip.dev/docs/modules/skip-sql/#contributing
Releases https://skip.dev/docs/modules/skip-sql/#releases
Overview https://skip.dev/docs/modules/skip-sql/#_top
Usage https://skip.dev/docs/modules/skip-sql/#usage
Connection example https://skip.dev/docs/modules/skip-sql/#connection-example
In-memory databases https://skip.dev/docs/modules/skip-sql/#in-memory-databases
Transactions https://skip.dev/docs/modules/skip-sql/#transactions
Bound parameters https://skip.dev/docs/modules/skip-sql/#bound-parameters
Schema Migration https://skip.dev/docs/modules/skip-sql/#schema-migration
Concurrency https://skip.dev/docs/modules/skip-sql/#concurrency
SQLCodable https://skip.dev/docs/modules/skip-sql/#sqlcodable
Querying with SQLPredicate https://skip.dev/docs/modules/skip-sql/#querying-with-sqlpredicate
Convenience Query Methods https://skip.dev/docs/modules/skip-sql/#convenience-query-methods
Primary keys and auto-increment columns https://skip.dev/docs/modules/skip-sql/#primary-keys-and-auto-increment-columns
Date fields https://skip.dev/docs/modules/skip-sql/#date-fields
Relations and joins https://skip.dev/docs/modules/skip-sql/#relations-and-joins
Implementation https://skip.dev/docs/modules/skip-sql/#implementation
SQLite Versions https://skip.dev/docs/modules/skip-sql/#sqlite-versions
Vendored SQLite Versions https://skip.dev/docs/modules/skip-sql/#vendored-sqlite-versions
SQLPlus https://skip.dev/docs/modules/skip-sql/#sqlplus
Building https://skip.dev/docs/modules/skip-sql/#building
Testing https://skip.dev/docs/modules/skip-sql/#testing
Contributing https://skip.dev/docs/modules/skip-sql/#contributing
Releases https://skip.dev/docs/modules/skip-sql/#releases
https://github.com/skiptools/skip-sql/releases
github.com/skiptools/skip-sql ↗https://github.com/skiptools/skip-sql
Contribution Guidehttps://skip.dev/docs/contributing/#local-libraries
Section titled “Usage”https://skip.dev/docs/modules/skip-sql/#usage
Section titled “Connection example”https://skip.dev/docs/modules/skip-sql/#connection-example
Section titled “In-memory databases”https://skip.dev/docs/modules/skip-sql/#in-memory-databases
Section titled “Transactions”https://skip.dev/docs/modules/skip-sql/#transactions
Section titled “Bound parameters”https://skip.dev/docs/modules/skip-sql/#bound-parameters
Section titled “Schema Migration”https://skip.dev/docs/modules/skip-sql/#schema-migration
Section titled “Helper Methods”https://skip.dev/docs/modules/skip-sql/#helper-methods
Section titled “Manual Migration”https://skip.dev/docs/modules/skip-sql/#manual-migration
Section titled “Concurrency”https://skip.dev/docs/modules/skip-sql/#concurrency
Locking And Concurrency ↗https://www.sqlite.org/lockingv3.html
Section titled “SQLCodable”https://skip.dev/docs/modules/skip-sql/#sqlcodable
Section titled “Querying with SQLPredicate”https://skip.dev/docs/modules/skip-sql/#querying-with-sqlpredicate
Section titled “Convenience Query Methods”https://skip.dev/docs/modules/skip-sql/#convenience-query-methods
Section titled “Checking Existence”https://skip.dev/docs/modules/skip-sql/#checking-existence
Section titled “Fetching”https://skip.dev/docs/modules/skip-sql/#fetching
Section titled “Batch Insert”https://skip.dev/docs/modules/skip-sql/#batch-insert
Section titled “Deleting All Rows”https://skip.dev/docs/modules/skip-sql/#deleting-all-rows
Section titled “Aggregate Functions”https://skip.dev/docs/modules/skip-sql/#aggregate-functions
Section titled “Primary keys and auto-increment columns”https://skip.dev/docs/modules/skip-sql/#primary-keys-and-auto-increment-columns
ROWIDs and the INTEGER PRIMARY KEY ↗https://sqlite.org/lang_createtable.html#rowids_and_the_integer_primary_key
Section titled “Date fields”https://skip.dev/docs/modules/skip-sql/#date-fields
Date And Time Functions ↗https://sqlite.org/lang_datefunc.html#overview
Section titled “Mapping Date to a REAL column”https://skip.dev/docs/modules/skip-sql/#mapping-date-to-a-real-column
Section titled “Mapping Date to a TEXT column”https://skip.dev/docs/modules/skip-sql/#mapping-date-to-a-text-column
Section titled “Relations and joins”https://skip.dev/docs/modules/skip-sql/#relations-and-joins
Section titled “Implementation”https://skip.dev/docs/modules/skip-sql/#implementation
SkipFFIhttps://skip.dev/docs/modules/skip-ffi
Section titled “SQLite Versions”https://skip.dev/docs/modules/skip-sql/#sqlite-versions
Section titled “Vendored SQLite Versions”https://skip.dev/docs/modules/skip-sql/#vendored-sqlite-versions
json ↗https://sqlite.org/json1.html
json_ ↗https://www.sqlite.org/json1.html
Android documentation ↗https://developer.android.com/reference/android/database/sqlite/package-summary
SQLPlushttps://skip.dev/docs/modules/skip-sql/#sqlplus
Section titled “SQLPlus”https://skip.dev/docs/modules/skip-sql/#sqlplus
json ↗https://sqlite.org/json1.html
Section titled “Using SQLPlus”https://skip.dev/docs/modules/skip-sql/#using-sqlplus
Section titled “JSON”https://skip.dev/docs/modules/skip-sql/#json
json ↗https://sqlite.org/json1.html
Section titled “Encryption”https://skip.dev/docs/modules/skip-sql/#encryption
SQLCipher site ↗https://www.zetetic.net/sqlcipher/
Signal ↗https://github.com/signalapp/sqlcipher
LibTomCrypt ↗https://github.com/libtom/libtomcrypt
Section titled “Encrypting an unencrypted database”https://skip.dev/docs/modules/skip-sql/#encrypting-an-unencrypted-database
Section titled “Building”https://skip.dev/docs/modules/skip-sql/#building
Section titled “Testing”https://skip.dev/docs/modules/skip-sql/#testing
Section titled “Contributing”https://skip.dev/docs/modules/skip-sql/#contributing
shared workspacehttps://skip.dev/docs/contributing
Contributor Agreement ↗https://source.skip.dev/clabot-config
Section titled “Releases”https://skip.dev/docs/modules/skip-sql/#releases
skiptools/skip-sql ↗https://github.com/skiptools/skip-sql/releases
Release 0.16.0 ↗https://github.com/skiptools/skip-sql/releases/tag/0.16.0
Release 0.15.1 ↗https://github.com/skiptools/skip-sql/releases/tag/0.15.1
Release 0.15.0 ↗https://github.com/skiptools/skip-sql/releases/tag/0.15.0
Release 0.14.0 ↗https://github.com/skiptools/skip-sql/releases/tag/0.14.0
Release 0.13.0 ↗https://github.com/skiptools/skip-sql/releases/tag/0.13.0
Release 0.12.1 ↗https://github.com/skiptools/skip-sql/releases/tag/0.12.1
Release 0.12.0 ↗https://github.com/skiptools/skip-sql/releases/tag/0.12.0
Release 0.11.0 ↗https://github.com/skiptools/skip-sql/releases/tag/0.11.0
Release 0.10.1 ↗https://github.com/skiptools/skip-sql/releases/tag/0.10.1
Release 0.10.0 ↗https://github.com/skiptools/skip-sql/releases/tag/0.10.0
github.com/skiptools/skip-sql/releases ↗https://github.com/skiptools/skip-sql/releases
.atom feed ↗https://github.com/skiptools/skip-sql/releases.atom
Edit pagehttps://github.com/skiptools/skip-sql/edit/main/README.md
Previous Sensors https://skip.dev/docs/modules/skip-device/
Next WebView https://skip.dev/docs/modules/skip-web/
Skip https://skip.dev/
https://github.com/orgs/skiptools
https://mas.to/@skiptools
https://x.com/skiptools
https://skip.dev/slack/
https://forums.skip.dev
https://skip.dev/feeds/
Documentationhttps://skip.dev/docs/
Moduleshttps://skip.dev/docs/modules/
Sample Appshttps://skip.dev/docs/samples/
Galleryhttps://skip.dev/gallery/
Getting Startedhttps://skip.dev/docs/gettingstarted/
Bloghttps://skip.dev/blog/
FAQhttps://skip.dev/docs/faq/
Comparisonhttps://skip.dev/compare/
Slackhttps://skip.dev/slack/
Forumshttps://forums.skip.dev
Sponsorhttps://skip.dev/sponsor/
Talkshttps://skip.dev/talks/fosdem2026/
Release Noteshttps://skip.dev/releases/
Feedshttps://skip.dev/feeds/
Privacyhttps://skip.dev/privacy/
Abouthttps://skip.dev/about/

Viewport: width=device-width, initial-scale=1

URLs of crawlers that visited me.