Gem install sqlite returns david macek unknown trust issue, error: database 'mingw32' is not valid (invalid or corrupted database (PGP signature)) error: database 'mingw64' is not valid (invalid or corrupted database (PGP signature)) error: database 'msys

Fairly new to rails, made some research on how to use it, I already installed npm, yarn, sqlite and ofcourse ruby with rubyinstaller-2.7.2-devkit. in my computer

installed sqlite properly in my windows 10 laptop.

$ sqlite3 --version
3.37.2 2022-01-06 13:25:41 872ba256cbf61d9290b571c0e6d82a20c224ca3ad82971edc46b29818d5d17a0

but when I run $ gem install sqlite3

error: mingw32: signature from "David Macek <david.macek.0@gmail.com>" is unknown trust
error: mingw64: signature from "David Macek <david.macek.0@gmail.com>" is unknown trust
error: msys: signature from "David Macek <david.macek.0@gmail.com>" is unknown trust
error: database 'mingw32' is not valid (invalid or corrupted database (PGP signature))
error: database 'mingw64' is not valid (invalid or corrupted database (PGP signature))
error: database 'msys' is not valid (invalid or corrupted database (PGP signature))
ERROR:  Error installing sqlite3:
        ERROR: Failed to build gem native extension.
    current directory: C:/Ruby27-x64/lib/ruby/gems/2.7.0/gems/sqlite3-1.4.2/ext/sqlite3
C:/Ruby27-x64/bin/ruby.exe -I C:/Ruby27-x64/lib/ruby/2.7.0 -r ./siteconf20220204-7536-686k2k.rb extconf.rb
checking for sqlite3.h... no
sqlite3.h is missing. Install SQLite3 from http://www.sqlite.org/ first.
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers.  Check the mkmf.log file for more details.  You may
need configuration options.

what could I do, in order to fix this kinds of issue, where should I start ?

I would start changing your setup. I tried to develop applications using Ruby in Windows before, but I was having a lot of situations with missing files like your case.

If you want to stick with Windows try using WSL2. I know some people using Windows with Docker for Ruby on Rails development, but I do not think it is a productive way to go.

I also recommend you to install Ruby using a version manager like chruby with ruby-install, rvm or rbenv.

Good luck.