Skip to content

Support user-defined functions in sqlite3 #16657

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
spiffytech opened this issue Nov 16, 2022 · 3 comments
Closed

Support user-defined functions in sqlite3 #16657

spiffytech opened this issue Nov 16, 2022 · 3 comments

Comments

@spiffytech
Copy link

SQLite's regex syntax errors out unless a user-defined regex function is defined.

User-defined functions are also useful for compensating for SQLite's poor datetime logic.

They can also be used with triggers to mimic Postgres' LISTEN/NOTIFY behavior.

I'd expect an implementation to resemble better-sqlite3's support for user-defined functions.
@dsherret
Copy link
Member

This doesn't seem actionable because we don't have sqlite built in? Maybe discuss in #11657?

@dsherret dsherret closed this as not planned Won't fix, can't repro, duplicate, stale Nov 16, 2022
@spiffytech
Copy link
Author

spiffytech commented Nov 16, 2022 •
edited
Loading

Ah sorry, didn't see that sqlite3 was a separate repo.

@dsherret
Copy link
Member

No problem!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@spiffytech @dsherret