Find how this tiny database is outperforming giants in its space.

DuckDB is an embedded SQL database that can be used directly from C, C++ or other programming languages without separate server process.

[{"selector":"#anim-1f451e4b-3f53-4496-b843-7d5591f788fa [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.499999886225725%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-5b96cee7-dfd3-4f46-aa92-114980622654","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0386310c-f2a8-429f-b4e9-c3f01d8f9b70","keyframes":{"transform":["translate3d(0px, 146.20810%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] It supports standard SQL and can be used to query, insert and manipulate data directly similar to other SQL databases like SQLite.

[{"selector":"#anim-27e616ef-e0ad-4ef3-bbb2-c67c4aaa92de [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.499999886225725%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-2963736f-a989-4ecf-9c40-9953c885845b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d220cbd4-baa0-4de7-b1ac-e1d22bffe25f","keyframes":{"transform":["translate3d(0px, 146.63171%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] DuckDB provides data types, functions and queries similar to bigger databases but runs directly in-process without separate server.

[{"selector":"#anim-22ce5f94-d101-4680-aa82-10e89121e58f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.499999886225725%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-04f4e94e-5e83-4e47-b4df-da90471276f7","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c8b03b6b-55a8-49ed-9a8e-ec7991c468d3","keyframes":{"transform":["translate3d(0px, 182.73998%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Being an embedded database, it has smaller footprint than SQLite and faster for analytical queries with advanced optimizations.

[{"selector":"#anim-7b81d54f-07b8-432b-a43c-e737260d5421 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.499999886225725%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-23ce42a7-c9d4-486e-9392-6a4eb499921b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1a105273-ca69-42ee-9d85-3bc4233edfed","keyframes":{"transform":["translate3d(0px, 139.88224%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Mother Duck is not a real database but just a fanciful analogy to refer conceptually to DuckDB which can be embedded or used like a mother to other programs.

[{"selector":"#anim-5b2870f5-9677-4534-8818-92e92d910767 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.499999886225725%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-75dfbb33-5f2c-4a88-adad-ca4bdb401f7c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d256a7bf-2b2b-4d48-9674-b6c83c5b8b98","keyframes":{"transform":["translate3d(0px, 147.79543%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] DuckDB aims to combine advantages of embedded databases and big analytical databases for applications with SQL data needs.

[{"selector":"#anim-9abe5835-7608-42d4-bd89-67d949bfedd0 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(12.499999886225725%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-2aefee46-a4a1-4077-bf11-54fffb2dcafc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8bef8e50-e93d-4c2f-822e-a55d9e337352","keyframes":{"transform":["translate3d(0px, 158.46813%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] It is a good option for programs that need local SQL data storage and queries without overhead of client-server databases.