{"id":46462,"library":"sqlite-hello","title":"sqlite-hello","description":"A minimal SQLite extension package that demonstrates the sqlite-dist build and distribution system. Version 0.1.0-alpha.79 is the latest alpha release. It provides a single function `hello()` that returns a greeting string, serving primarily as a test and learning tool for building SQLite extensions with sqlite-dist. Unlike full-featured SQLite extensions (e.g., sqlean, sqlpkg), this package is intentionally minimal, focusing on illustrating the packaging and loading process. Releases are infrequent, as development is tied to sqlite-dist improvements.","status":"active","version":"0.1.0-alpha.79","language":"javascript","source_language":"en","source_url":null,"tags":["javascript","typescript"],"install":[{"cmd":"npm install sqlite-hello","lang":"bash","label":"npm"},{"cmd":"yarn add sqlite-hello","lang":"bash","label":"yarn"},{"cmd":"pnpm add sqlite-hello","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Required as the runtime for loading SQLite extensions built with sqlite-dist.","package":"sqlite-dist","optional":false}],"imports":[{"note":"ESM-only; CommonJS require is not supported.","wrong":"const hello = require('sqlite-hello')","symbol":"hello","correct":"import { hello } from 'sqlite-hello'"},{"note":"Default export is a function that returns the hello extension object.","wrong":"const sqliteHello = require('sqlite-hello')","symbol":"sqlite-hello (default)","correct":"import sqliteHello from 'sqlite-hello'"},{"note":"Type-only import when using TypeScript.","wrong":null,"symbol":"type HelloExtension","correct":"import type { HelloExtension } from 'sqlite-hello'"}],"quickstart":{"code":"import { hello } from 'sqlite-hello';\nimport { loadExtension, Database } from 'sqlite-dist';\n\nconst db = new Database();\nawait loadExtension(db, hello);\nconst result = db.query('SELECT hello(\"world\")')\nconsole.log(result); // [{ hello: 'Hello, world!' }]","lang":"typescript","description":"Load the hello extension into sqlite-dist, then call the hello function."},"warnings":[{"fix":"Update sqlite-dist to >=0.2.0.","message":"sqlite-hello v0.1.0-alpha.79 requires sqlite-dist >= 0.2.0. Older versions incompatible.","severity":"breaking","affected_versions":"<0.1.0-alpha.79"},{"fix":"Use 'helloAsync()' for async operations.","message":"The synchronous 'hello()' function is deprecated in favor of async 'helloAsync()' starting from v0.2.0.","severity":"deprecated","affected_versions":">=0.2.0"},{"fix":"Use `import { hello } from 'sqlite-hello'` instead of `import hello from 'sqlite-hello'`.","message":"Default export returns a module object, not the extension function directly. Use named import for clarity.","severity":"gotcha","affected_versions":"*"},{"fix":"Update extension functions to accept optional options object.","message":"In v0.3.0, the extension function signature changed from (db: Database) => void to (db: Database, options?: object) => void.","severity":"breaking","affected_versions":">=0.3.0"},{"fix":"Use only with sqlite-dist runtime.","message":"sqlite-hello only works with sqlite-dist. Cannot be loaded with better-sqlite3 or node-sqlite3.","severity":"gotcha","affected_versions":"*"}],"env_vars":null,"search_vec":"'0.1.0':20 'alpha':25 'alpha.79':21 'build':15,47 'demonstr':10 'develop':80 'dist':14,53,86 'distribut':17 'e.g':60 'extens':7,49,59 'featur':57 'focus':68 'full':56 'full-featur':55 'function':31 'greet':36 'hello':3,32 'illustr':70 'improv':87 'infrequ':78 'intent':66 'javascript':88 'latest':24 'learn':44 'load':74 'minim':5,67 'packag':8,64,72 'primarili':39 'process':75 'provid':28 'releas':26,76 'return':34 'serv':38 'singl':30 'sqlean':61 'sqlite':2,6,13,48,52,58,85 'sqlite-dist':12,51,84 'sqlite-hello':1 'sqlpkg':62 'string':37 'system':18 'test':42 'tie':82 'tool':45 'typescript':89 'unlik':54 'version':19","created_at":"2026-06-07T13:00:03.061073+00:00","updated_at":"2026-06-07T13:00:03.061073+00:00","problems":[{"fix":"Run `npm install sqlite-hello` or add it to your package.json.","cause":"Missing dependency in package.json or not installed.","error":"Cannot find module 'sqlite-hello'"},{"fix":"Update to >=0.1.0 or use `import hello from 'sqlite-hello'`.","cause":"Using an older version (pre-0.1.0) where the function was exported as default only.","error":"The module 'sqlite-hello' does not provide a named export 'hello'"},{"fix":"Use sqlite-dist to load the extension: `await loadExtension(db, hello)`.","cause":"Trying to load the extension with a non-sqlite-dist runtime.","error":"Error: Not a valid SQLite extension"},{"fix":"Use named import: `import { hello } from 'sqlite-hello'`.","cause":"Default import returns the extension module object, not the function.","error":"TypeError: hello is not a function"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"sqlite-hello","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-07","next_check":"2026-09-05","install_tag":null}}