Managing your data using FastAPI and Piccolo Admin
Speaker: Daniel Townsend
Summary
Making your data easy to consume, whether via an API or an admin interface, is very important. This talk will introduce Piccolo ORM, which is a library which helps you create a REST API with Swagger documentation in record time, along with a modern admin GUI which will delight your users. It is built on top of Postgres, and a modern async database adapter, to deliver impressive performance.
Description
Introduction to FastAPI and Piccolo ORM
FastAPI is a popular async web framework, which makes building a REST API with Swagger docs very easy.
Piccolo is an async ORM and query builder, primarily for PostgreSQL, which works well with FastAPI. It has lots of 'batteries included' - such as the admin interface.
A brief overview of both tools will be given.
Does async matter
A quick overview of async in Python, and why it's a useful tool to have in your tool belt.
Why PostgreSQL?
Piccolo primarily supports PostgreSQL. A quick overview of the reasons for this will be given.
Creating a REST API and admin GUI in 5 minutes
With FastAPI and Piccolo you can create API's very efficiently. The demo will use Piccolo to scaffold an entire web application in just a few minutes, which exposes your data in an API, and via a nice admin interface.
A brief tour of the admin GUI, and its powerful filtering abilities
The Piccolo admin has powerful filtering capabilities, which will be demoed briefly. Coupled with the CSV export abilities, makes it a great tool for users consuming your data.
Some other advantages of Piccolo ORM (such as the playground)
Piccolo ships with a tool called the playground. It consists of a pre-populated database, and iPython shell, which provides a low friction way of learning Piccolo's query syntax, and about databases in general. The benefits of these sorts of tools will be briefly discussed, along with some examples of the more innovative query syntax that Piccolo provides.
SLIDES
The slides are now available to download: https://github.com/piccolo-orm/pymdb/raw/master/pydata_global_presentation.pdf
The code used in the demo is also available: https://github.com/piccolo-orm/pymdb/
Daniel Townsend's Bio
Dan is a full stack developer and tech lead, with a love for Python, and creating nice UI. He is based in the UK, and started his career after picking up a secondhand book on HTML, which sparked a lifelong interest in building digital products. He's often found tinkering with web sockets, Postgres, and asyncio.
GitHub: https://github.com/dantownsend/
Twitter: https://twitter.com/danieltownsend/
LinkedIn: https://www.linkedin.com/in/danieltownsenduk/
Website: https://dantownsend.co.uk/
PyData Global 2021
Website: https://pydata.org/global2021/
LinkedIn: https://www.linkedin.com/company/pydata-global
Twitter: https://twitter.com/PyData
www.pydata.org
PyData is an educational program of NumFOCUS, a 501(c)3 non-profit organization in the United States. PyData provides a forum for the international community of users and developers of data analysis tools to share ideas and learn from each other. The global PyData network promotes discussion of best practices, new approaches, and emerging technologies for data management, processing, analytics, and visualization. PyData communities approach data science using many languages, including (but not limited to) Python, Julia, and R.
PyData conferences aim to be accessible and community-driven, with novice to advanced level presentations. PyData tutorials and talks bring attendees the latest project features along with cutting-edge use cases.
00:00 Welcome!
00:10 Help us add time stamps or captions to this video! See the description for details.
Want to help add timestamps to our YouTube videos to help with discoverability? Find out more here: https://github.com/numfocus/YouTubeVideoTimestamps