search

BemiHQ / BemiDB

Postgres read replica optimized for analytics
https://bemidb.com
GNU Affero General Public License v3.0
1.05k stars 18 forks source link

Unsupported PostgreSQL type: inet #12

Closed firstpromoter closed 3 days ago

firstpromoter commented 3 days ago

We get an error when doing sync for an inet column:

panic: Unsupported PostgreSQL type: inet

goroutine 1 [running]:
main.(*PgSchemaColumn).parquetPrimitiveTypes(0x14000053578)
        /Users/exaspark/Documents/Code/BemiHQ/BemiDB/src/pg_schema_column.go:300 +0x62c

Maybe just convert it to string.

Some out of scope questions: Also, when can we expect incremental sync or similar? The current sync can take 2 hours and there are quite wasted resources to sync from the beginning each time.

Also, any plans for materialized views?

exAspArk commented 3 days ago

Hi @firstpromoter — thanks for submitting this issue!

We've added support for inet and other Postgres network address types (represented as strings). Would you be able to download the latest BemiDB version and try again?

Also, when can we expect incremental sync or similar? The current sync can take 2 hours and there are quite wasted resources to sync from the beginning each time. Also, any plans for materialized views?

Yes, absolutely! We almost finished adding support for most of the Postgres data types. Incremental syncing is next on our roadmap. Materialized views are also on the roadmap, but we'll prioritize them a bit later.