Splitgraph has been acquired by EDB! Read the blog post.

Types

This page details all types supported by Seafowl, as well as how they're converted when querying Seafowl via HTTP and via the PostgreSQL endpoint:

Arrow typeSQL type (in DDL)JSON type (HTTP endpoint)PostgreSQL type
Int16SMALLINTintegerSupported
Int32INTintegerSupported
Int64BIGINTintegerSupported
Utf8CHARstringSupported
Utf8VARCHARstringSupported
Utf8TEXTstringSupported
DecimalDECIMAL(p,s)UnsupportedUnsupported
Float32FLOATnumberSupported
Float32REALnumberSupported
Float64DOUBLEnumberSupported
BooleanBOOLEANbooleanSupported
Date32DATEstring YYYY-MM-DDSupported
Timestamp(us)TIMESTAMPstring YYYY-MM-DD HH:mm:ss.sssSupported

Seafowl currently doesn't support other types like arrays, JSON objects, nested Parquet types and custom data types. You may wish to store serialize these as strings and manage them at the application level.