The SQLite database can be compiled to webassembly and served using static website hosting. SQLite stores data using files so you can avoid downloading the whole thing by making clever use of HTTP range requests which accept a certain byte range as a
204 partial request. That means you can query large datasets and query it with kilobytes of overhead.
SQLite can also be used for full text search using the FTS5 plugin making it a portable static site search engine like stork-search for significantly larger datasets.