Listing Links for tag Database

Database x

Tags

see all

SchemaHero - A modern approach to database schema migrations (schemahero.io)

software Database schema migration

SchemaHero is an open-source tool designed for database schema migrations, making it easier to manage sequenced migration scripts across different environments.

12

200

47

63
Look ma, I wrote a new JIT compiler for PostgreSQL – Pinaraf's website (www.pinaraf.info)

PostgreSQL JIT Compiler programming Database Technology

The article discusses the creation of pg-copyjit, a new JIT compiler for PostgreSQL developed by the author after being inspired by a recently proposed JIT compiler construction methodology. It explores the limitations of using LLVM for JIT compilation in PostgreSQL and introduces the advantages of the copy-and-patch methodology used by pg-copyjit. The author shares insights into the current performance of pg-copyjit, as well as future goals for optimization and expanding architecture support. Links to a research paper that inspired the project, the project’s GitHub repository, and a mentioned tool, PoWA, are also provided.
Main Points
- Introduction of pg-copyjitThe author introduced pg-copyjit, a new JIT compiler for PostgreSQL, inspired by a new compiler construction methodology.
- Copy-and-patch methodologypg-copyjit is designed using a copy-and-patch methodology, allowing for faster query execution compared to traditional JIT compilers like LLVM.
- Performance and future plansThe current implementation of pg-copyjit shows significant performance improvements and plans for future optimization and support for multiple architectures are outlined.
- Limitations of LLVMThe limitations and challenges of using LLVM for JIT compilation in PostgreSQL were highlighted, including its expensive optimization process.
12

200

47

63