After I asked a question about SQL (Is there an embedded database protocol which is faster than SQLite for VERY large databases?), a more specific, but still related, question occurred to me:
Do any embedded/serverless database protocols have a larger feature set than SQLite?
Are there are any embedded database protocols with a larger feature set than SQLite? For example, postgresql, which is not an embedded protocol, supports multiple indexing methods (btree, hash, gist, and gin), whereas SQLite only supports a default method (b-trees, I think). Is there an embedded protocol which does support the postgresql indexing methods? Are these indexing methods, or any other features which SQLite lacks, important for optimizing the performance of large databases?
Can I post this question as well, or is it considered bad form to ask two so closely related questions?