sqlite_protobuf
sqlite_protobuf copied to clipboard
A SQLite extension for extracting values from serialized Protobuf messages
Bumps [protobuf](https://github.com/protocolbuffers/protobuf) from 3.6.1 to 3.18.3. Release notes Sourced from protobuf's releases. Protocol Buffers v3.18.3 C++ Reduce memory consumption of MessageSet parsing This release addresses a Security Advisory for C++...
Thanks to Scott Lamb for the tip, posted on Hacker News: https://news.ycombinator.com/item?id=19284460 static const std::regex* kPathElementRegexp = new std::regex("..."); This will avoid having to recompile the regular expression on each...
Protobuf 3.6.1 contains a segmentation fault bug (https://github.com/protocolbuffers/protobuf/issues/2974) that is triggered on Linux hosts while running unit tests. The bug is fixed in Protobuf 3.7. In the meantime, 7b323af1b00452130a911181c47572ee6589eb27 modified...
* There are two switch statements that cover all different field types, one for returning a default value of an optional field that is not present, and one for returning...
Since `protobuf_extract` returns the default value for an unpopulated optional field, it would be useful to be able to know whether the field exists or not.
Ideally this would be a table-valued function that is similar to [`json_each()`][json1_each] from the JSON1 extension: SELECT protobuf_extract(protobuf, "Person", "$.name") FROM people, protobuf_each(people, "Person", "$.phones") WHERE protobuf_each.value LIKE "607-%"; [json1_each]:...