pg_bitemporal
Kirby
pg_bitemporal | Kirby | |
---|---|---|
7 | 56 | |
140 | 1,199 | |
1.4% | 1.2% | |
0.0 | 9.9 | |
about 2 years ago | 7 days ago | |
PLpgSQL | PHP | |
BSD 3-clause "New" or "Revised" License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pg_bitemporal
-
The Guide to PostgreSQL Data Change Tracking
I feel like i keep yelling the following, but bitemporal tables.
- https://aiven.io/blog/two-dimensional-time-with-bitemporal-d...
- https://github.com/scalegenius/pg_bitemporal
4 timestamps and some ugly queries.
-
Eventual Business Consistency
People here may also be interested to see this analysis of the state of SQL:2011 "temporal table" feature adoption: https://illuminatedcomputing.com/posts/2019/08/sql2011-surve...
I don't think much has really changed since, and I'm not sure Postgres is any closer to addressing this natively (although there have been extensions, e.g. https://github.com/scalegenius/pg_bitemporal).
- Show HN: I made a CMS that uses Git to store your data
-
Record history / Temporal table question
Something more sophisticated would be https://github.com/scalegenius/pg_bitemporal
- PostgreSQL 14 Released
-
Bitemporal History
Sure, I can appreciate that native support for a feature like this is nice.
As I understand it, most implementations (including another one for bitemporality[1]) involve either audit tables, as you mention, and/or additional support columns. It's as if the "now" representation is simply a narrow lens onto the underlying data.
That said, PostgreSQL encodes and has battle-tested decades of database functionality including an ecosystem around those, so I'd be a little wary of switching technology even if it does solve one individual problem thoroughly. Everything has to start somewhere, though.
[1] - https://github.com/scalegenius/pg_bitemporal
Kirby
-
Show HN: Primo – a visual CMS with Svelte blocks, a code editor, and SSG
Not sure if this is what you’re after but give https://getkirby.com/ a try
- Kirby: Simple Flat-File CMS
-
Grav is a modern open-source flat-file CMS
Personally think https://getkirby.com is the entry to beat but I guess it’s just because I’m used to it and it works incredibly well for my use case.
-
What kind of CMS for custom website?
Check out KirbyCMS. A PHP based files-only CMS. Can also be used as headless CMS. Works on most shared hosts and doesn't need a database. You'll have to do some basic PHP for the templates, though.
- What technology do you use to build websites these days?
-
WP20 and Audrey Scholars – Matt Mullenweg
I guess it depends what you need to build. I used to use Wordpress for all my personal and client projects but I then moved to Kirby[0] and I couldn’t be happier.
But I think it highly depends on what kind of projects you work on.
[0] https://getkirby.com/
-
Ask HN: How do I make a website in 2023?
I can recommend Kirby (https://getkirby.com/), a flat file PHP CMS. It’s fast, has a panel to update data and can be hosted on any basically any PHP host. Just use the quite simple PHP-templates and add CSS & JS like you already know how to do. No need to complicate things.
-
Go with PHP
PHP has a lot of top tier CMSes. IMHO bunch of them are even better than Statamic. Craft CMS (https://craftcms.com/) is a lot more mature database based CMS. Kirby (https://getkirby.com/) is better at flat-file and has a lot better admin interface. Twill (https://twillcms.com/) is better integrated in Laravel and is fully open-source. Statamic mostly feels like it's sitting besides Laravel and they call themselves Laravel based for marketing.
- Feedback call for Tailkits ✨
- Headless CMS with the best documentation for vue/nuxt.js
What are some alternatives?
temporal_tables - Temporal Tables PostgreSQL Extension
Grav - Modern, Crazy Fast, Ridiculously Easy and Amazingly Powerful Flat-File CMS powered by PHP, Markdown, Twig, and Symfony
Reladomo - Reladomo is an enterprise grade object-relational mapping framework for Java.
WordPress - WordPress, Git-ified. This repository is just a mirror of the WordPress subversion repository. Please do not send pull requests. Submit pull requests to https://github.com/WordPress/wordpress-develop and patches to https://core.trac.wordpress.org/ instead.
crux - General purpose bitemporal database for SQL, Datalog & graph queries. Backed by @juxt [Moved to: https://github.com/xtdb/xtdb]
Next.js - The React Framework
wasmer.io - The Wasmer.io website
ProcessWire - ProcessWire 3.x is a friendly and powerful open source CMS with a strong API.
outstatic - Outstatic - A static CMS for Next.js
Textpattern - A flexible, elegant, fast and easy-to-use content management system written in PHP.
Publii - The most intuitive Static Site CMS designed for SEO-optimized and privacy-focused websites.
Bludit - Simple, Fast, Secure, Flat-File CMS