{"id":429,"date":"2007-11-30T17:09:13","date_gmt":"2007-11-30T16:09:13","guid":{"rendered":"http:\/\/www.itwriting.com\/blog\/?p=429"},"modified":"2007-11-30T17:09:13","modified_gmt":"2007-11-30T16:09:13","slug":"extend-sqlite-with-delphi-functions","status":"publish","type":"post","link":"https:\/\/www.itwriting.com\/blog\/429-extend-sqlite-with-delphi-functions.html","title":{"rendered":"Extend SQLite with Delphi functions"},"content":{"rendered":"<p>I have a couple of open source projects on the go, one of which is a <a href=\"http:\/\/www.itwriting.com\/sqlitesimple.php\">simple Delphi wrapper<\/a> for <a href=\"http:\/\/www.sqlite.org\">SQLite<\/a>. Lukas Gebauer has now added experimental support for user defined functions. This lets you in effect extend the SQL understood by SQLite to include your own custom functions, written in Delphi.<\/p>\n<p>To try out the feature, <a href=\"http:\/\/www.itwriting.com\/sqlitesimple.php\">download the wrapper<\/a> and have a look at the file sqlite3udf.pas.<\/p>\n<div class=\"wlWriterSmartContent\" id=\"scid:0767317B-992E-4b12-91E0-4F059A8CECA8:233f41d0-ba63-4da6-8d01-a1afd024ee6a\" style=\"padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px\">Technorati tags: <a href=\"http:\/\/technorati.com\/tags\/delphi\" rel=\"tag\">delphi<\/a>, <a href=\"http:\/\/technorati.com\/tags\/sqlite\" rel=\"tag\">sqlite<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I have a couple of open source projects on the go, one of which is a simple Delphi wrapper for SQLite. Lukas Gebauer has now added experimental support for user defined functions. This lets you in effect extend the SQL understood by SQLite to include your own custom functions, written in Delphi. To try out &hellip; <a href=\"https:\/\/www.itwriting.com\/blog\/429-extend-sqlite-with-delphi-functions.html\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Extend SQLite with Delphi functions<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,80],"tags":[],"class_list":["post-429","post","type-post","status-publish","format-standard","hentry","category-delphi","category-software-development"],"_links":{"self":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/comments?post=429"}],"version-history":[{"count":0,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/429\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/media?parent=429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/categories?post=429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/tags?post=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}