sql-js / sql-js/sql.js

what is the upper limit of number of user defined function and relationship to `RESERVED_FUNCTION_POINTERS`

Open
#215 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
JavaScript
Stars
13.7k
Forks
1.1k
PR merge metrics
No merged PRs in 30d

Description

Hi,

I ran into Finished up all reserved function pointers. Use a higher value for RESERVED_FUNCTION_POINTERS -- I understand I could build sql.js with a higher value for RESERVED_FUNCTION_POINTERS, but I just wanted to make sure the issue was actually the number of UDFs:

is there a rule of thumb number of user defined functions? I ran into this problem with about 5 unique ones (but I call .create_function quite a few times because i need to update the udf) --- is the function pointers counted by distinct udf names, or the number that create_function is called?

Would the RESERVED_FUNCTION_POINTERS correspond directly to the number of .create_function or distinct UDFs, or neither of the two?

Thanks so much!!

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

The issue names no source file, test, or entry point. Start by tracing sql.js's SQLite UDF registration and RESERVED_FUNCTION_POINTERS handling, then document whether repeated create_function calls or distinct functions consume pointers; a reproducible case and clear rule of thumb would define done.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, sqlite, wasm
Domain
databases
Issue type
Documentation
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
15/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.