sparklemotion / sparklemotion/sqlite3-ruby

Incomplete PRAGMA support

Open
#559 10 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Ruby
Stars
845
Forks
220
Avg merge
2d 17h
Merged PRs (30d)
3

Description

I have noticed some inconsistencies in the handling for SQLite pragmas.

  1. There is a setter for busy_timeout= but no getter. Likewise for ignore_check_constraints=.
  2. No accessors for analysis_limit hard_heap_limit trusted_schema
  3. No method for optimize
  4. No methods for function_list module_list pragma_list
  5. No methods for table_list table_xinfo

For the last, SQLite supports 3 pragmas for index and table:

  • thing_list
  • thing_info
  • thing_xinfo

The gem I have installed, version 2.0.4, has methods for all three index pragmas but only the table_info method.

Some of these may not make sense to support, but these are my findings. Separately, I have some ideas about how to reorganize lib/sqlite3/pragmas.rb.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Review lib/sqlite3/pragmas.rb and compare the existing index and table pragma methods with the requested SQLite pragmas. Decide which missing accessors and methods are appropriate to support, then verify that each selected pragma is exposed consistently; the issue is complete when the chosen support is implemented.

Written by the indexing model from the issue text.

Assessment

Tech stack
ruby, sqlite
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.