In 3 lines

Push the serialized data of protocol buffers into sqlite.

Create a blob column in sqlite
When plunging, use buffer
Use str to load

(It's just treated as a binary regardless of protobuf)

Example

`person.proto`


message Person {
   optional string name = 1;
   optional int32 age = 2;
 }

`sample.py`


#!/usr/bin/env python
# -*- coding: utf-8 -*-

import sqlite3
from person_pb2 import Person


if __name__ == '__main__':
    #Connect to database and create table
    conn = sqlite3.connect(":memory:")
    c = conn.cursor()
    c.execute("create table people (person blob)")

    p = Person(name="John Doe", age=128)
    print p

    #writing
    wb = buffer(p.SerializeToString())
    c.execute("insert into people values (?)", [wb])

    #Read
    c.execute("select * from people")
    rb = c.fetchone()[0]
    q = Person()
    q.ParseFromString(str(rb))
    print q

result

name: "John Doe"                                      
age: 128                                              
                                                      
name: "John Doe"                                      
age: 128

I was able to read and write.

Recommended Posts

Put protocol buffers into sqlite with python

[Python] [SQLite3] Operate SQLite with Python (Basic)

Read Protocol Buffers data in Python3

Easily handle lists with python + sqlite3

Easily handle databases with Python (SQLite3)

How to import CSV and TSV files into SQLite with Python

INSERT into MySQL with Python [For beginners]

Save / load in-memory DB with python sqlite3

Trying to handle SQLite3 with Python [Note]

[TensorFlow] Python ⇔ Protocol Buffers ⇔ GPU / Distributed Computing