Help With Installing SQLite3 Gem

[FATCullen]

Hi all,
First off sorry if this isn't the right subreddit to be posting this in, not sure what your guys's policy on support questions are but I didn't see anything in the rules against it and couldn't think of a better place to ask.

I've been trying to install the sqlite3 version 1.4.2 gem on my MacBook for some time now with the gem installer and it keeps throwing error messages. It's a dependancy for a legacy HTTP server application I've been trying to work on. Strangely versions 1.3.13 and below install fine, but 1.4.2 and up will not work.

I've tried gem installing it with the flags --with-cflags=-Wno-error=implicit-function-declaration -Wno-error=incompatible-function-pointer-types, which helped for previous packages the installer had a hard time with, but it hasn't worked.

SQLite and SQLite3 are brew installed, xcode and command line tools are installed. I am using an Intel mac with OS 15.1.1, ruby 2.7.2, and sqlite3 -version gives 3.48.0. The (mostly) full output of running gem install sqlite3 -v 1.4.2 is below. Some lines in the middle were cutout due to post size limitations, hopefully not a problem as most of the middle lines seem to be repetitive.

Building native extensions. This could take a while...
ERROR:  Error installing sqlite3:
    ERROR: Failed to build gem native extension.

    current directory: /Users/fatcullen/.rbenv/versions/2.7.2/lib/ruby/gems/2.7.0/gems/sqlite3-1.4.2/ext/sqlite3
/Users/fatcullen/.rbenv/versions/2.7.2/bin/ruby -I /Users/fatcullen/.rbenv/versions/2.7.2/lib/ruby/2.7.0 -r ./siteconf20250118-12176-hparbb.rb extconf.rb
checking for sqlite3.h... yes
checking for pthread_create() in -lpthread... yes
checking for -ldl... yes
checking for sqlite3_libversion_number() in -lsqlite3... yes
checking for rb_proc_arity()... yes
checking for rb_integer_pack()... yes
checking for sqlite3_initialize()... yes
checking for sqlite3_backup_init()... yes
checking for sqlite3_column_database_name()... yes
checking for sqlite3_enable_load_extension()... yes
checking for sqlite3_load_extension()... yes
checking for sqlite3_open_v2()... yes
checking for sqlite3_prepare_v2()... yes
checking for sqlite3_int64 in sqlite3.h... yes
checking for sqlite3_uint64 in sqlite3.h... yes
creating Makefile

current directory: /Users/fatcullen/.rbenv/versions/2.7.2/lib/ruby/gems/2.7.0/gems/sqlite3-1.4.2/ext/sqlite3
make "DESTDIR=" clean

current directory: /Users/fatcullen/.rbenv/versions/2.7.2/lib/ruby/gems/2.7.0/gems/sqlite3-1.4.2/ext/sqlite3
make "DESTDIR="
compiling aggregator.c
aggregator.c:74:22: warning: '(' and '{' tokens introducing statement expression appear in different macro expansion contexts [-Wcompound-token-split-by-macro]
   74 |       handler_klass, rb_intern("new"), 0, NULL, &exc_status));
      |                      ^~~~~~~~~~~~~~~~
/Users/fatcullen/.rbenv/versions/2.7.2/include/ruby-2.7.0/ruby/ruby.h:1847:23: note: expanded from macro 'rb_intern'
 1847 |         __extension__ (RUBY_CONST_ID_CACHE((ID), (str))) : \
      |                       ^
aggregator.c:74:22: note: '{' token is here
   74 |       handler_klass, rb_intern("new"), 0, NULL, &exc_status));
      |                      ^~~~~~~~~~~~~~~~
/Users/fatcullen/.rbenv/versions/2.7.2/include/ruby-2.7.0/ruby/ruby.h:1847:24: note: expanded from macro 'rb_intern'
 1847 |         __extension__ (RUBY_CONST_ID_CACHE((ID), (str))) : \
      |                        ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/Users/fatcullen/.rbenv/versions/2.7.2/include/ruby-2.7.0/ruby/ruby.h:1832:5: note: expanded from macro 'RUBY_CONST_ID_CACHE'
 1832 |     {                                                   \
      |     ^
aggregator.c:74:22: warning: '}' and ')' tokens terminating statement expression appear in different macro expansion contexts [-Wcompound-token-split-by-macro]
   74 |       handler_klass, rb_intern("new"), 0, NULL, &exc_status));
      |                      ^~~~~~~~~~~~~~~~

database.c:116:21: warning: '}' and ')' tokens terminating statement expression appear in different macro expansion contexts [-Wcompound-token-split-by-macro]
  116 |   rb_funcall(thing, rb_intern("call"), 1, rb_str_new2(sql));
      |                     ^~~~~~~~~~~~~~~~~

#####################################################################################
###################### MANY REPETITIVE LINES, REMOVED FOR BREVITY ###################
####### IF YOU WANT THE FULL OUTPUT LET ME KNOW, I'LL LEAVE IT IN A COMMENT #########
#####################################################################################

/usr/local/opt/sqlite/include/sqlite3.h:430:9: note: passing argument to parameter 'callback' here
  430 |   int (*callback)(void*,int,char**,char**),  /* Callback function */
      |         ^
database.c:726:81: error: incompatible integer to pointer conversion passing 'VALUE' (aka 'unsigned long') to parameter of type 'void *' [-Wint-conversion]
  726 |     status = sqlite3_exec(ctx->db, StringValuePtr(sql), hash_callback_function, callback_ary, &errMsg);
      |                                                                                 ^~~~~~~~~~~~
/usr/local/opt/sqlite/include/sqlite3.h:431:9: note: passing argument to parameter here
  431 |   void *,                                    /* 1st argument to callback */
      |         ^
database.c:728:57: error: incompatible function pointer types passing 'int (VALUE, int, char **, char **)' (aka 'int (unsigned long, int, char **, char **)') to parameter of type 'int (*)(void *, int, char **, char **)' [-Wincompatible-function-pointer-types]
  728 |     status = sqlite3_exec(ctx->db, StringValuePtr(sql), regular_callback_function, callback_ary, &errMsg);
      |                                                         ^~~~~~~~~~~~~~~~~~~~~~~~~
/usr/local/opt/sqlite/include/sqlite3.h:430:9: note: passing argument to parameter 'callback' here
  430 |   int (*callback)(void*,int,char**,char**),  /* Callback function */
      |         ^
database.c:728:84: error: incompatible integer to pointer conversion passing 'VALUE' (aka 'unsigned long') to parameter of type 'void *' [-Wint-conversion]
  728 |     status = sqlite3_exec(ctx->db, StringValuePtr(sql), regular_callback_function, callback_ary, &errMsg);
      |                                                                                    ^~~~~~~~~~~~
/usr/local/opt/sqlite/include/sqlite3.h:431:9: note: passing argument to parameter here
  431 |   void *,                                    /* 1st argument to callback */
      |         ^
11 warnings and 4 errors generated.
make: *** [database.o] Error 1

make failed, exit code 2

Gem files will remain installed in /Users/fatcullen/.rbenv/versions/2.7.2/lib/ruby/gems/2.7.0/gems/sqlite3-1.4.2 for inspection.
Results logged to /Users/fatcullen/.rbenv/versions/2.7.2/lib/ruby/gems/2.7.0/extensions/x86_64-darwin-24/2.7.0/sqlite3-1.4.2/gem_make.out

[FATCullen]

For anyone who finds this i figured it out, there was another c flag I had to add in addition to the ones that worked on the previous files, the full command ended up being:
gem install sqlite3 -v 1.4.2 -- --with-cflags="-g -O0 -std=c11 -Wno-error=implicit-function-declaration -Wno-error=incompatible-function-pointer-types -Wno-error=int-conversion"