Architecture-of-consoles
blog
Architecture-of-consoles | blog | |
---|---|---|
8 | 11 | |
787 | 9 | |
- | - | |
9.2 | 6.0 | |
15 days ago | 3 months ago | |
Creative Commons Attribution 4.0 | Creative Commons Zero v1.0 Universal |
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.
Architecture-of-consoles
-
Sega Saturn Architecture – A practical analysis
Ah no worries! From my side I was only trying to explain more about the origins of the article, since I see it often mentioned/speculated in many forums.
By the way, I'm always open to criticism ! (https://github.com/flipacholas/Architecture-of-consoles/issu...)
-
Wii Architecture – A Practical Analysis
Author here! Surprised to see it shared! This article was the first one where I studied how a cryptography-based system worked and how it was subsequently broken, back in late 2019. Lot of things in the website have changed since then.
For this reason I humbly ask, if you find any mistakes, please report them here:
https://github.com/flipacholas/Architecture-of-consoles/issu...
That will make sure I don’t miss them, thanks!
-
Xbox 360 Architecture
No nitpick is too small or too big :) I've just logged your comment on the repo (https://github.com/flipacholas/Architecture-of-consoles/issu...) so I remember to take a look at it after I get back home.
-
PlayStation 3 Architecture | A Practical Analysis
Yeah, if anyone spots other issues can you log it first on the repo please? (https://github.com/flipacholas/Architecture-of-consoles/issues). Hope I don't sound too bossy, it's just that I can organise it better considering other forums may also spot mistakes.
-
Playstation 3 Architecture
Alternative edition without styles: https://classic.copetti.org/writings/consoles/playstation-3/
(ideal if you use accessibility tools, like text to speech, or want to read from an eBook or legacy browser)
If you spot a mistake, please log an issue on the repo (https://github.com/flipacholas/Architecture-of-consoles). Thanks!
-
Architecture of the Playstation
Oh what an amazing feeling seeing one of my articles here. Let me share you a bit of history about this one:
- A year ago, an old version of this article got shared in hn (https://news.ycombinator.com/item?id=22932134) and since then, google started positioning my site in their search results, and many forums started noticing the site. Yay!
- Fast forward, I graduated from uni, continued working on more articles in my free time, and with all the newly acquired knowledge, I decided to re-write the old PS1 article to make it much more informational and accurate - This is the one you are seeing right now.
- The rewrite wasn’t easy, though. Luckily, I found very kind and talented experts that lent me a hand, you can see them credited in the ‘Changelog’ at the end of the article. Curiously enough, we are still debating on Discord about some discrepancies regarding the main diagram shown in the article. LSI’s docs (the CPU manufacturer) and Sony’s docs contradict each other when they explain the layout of the CPU’s ‘main’ bus! But don’t worry about it, it doesn’t affect any statement in the article. It’s more of a need to have everything as accurate as possible.
Finally, I’m always open to comments, improvements, suggestions, anything really! I share the writings here (https://github.com/flipacholas/Architecture-of-consoles) to discuss improvements but you can also find my email in the site.
blog
- Versioning data in Postgres? Testing a Git like approach
-
A Different Type of SQL Recursion with PostgreSQL
Originally published at https://github.com/vb-consulting/blog/discussions/1
A follow up on this article was written today
[Recursion with PostgreSQL, Follup 1, Perfomances](https://github.com/vb-consulting/blog/discussions/4)
-
Recursion with PostgreSQL Follow-Up 3 - Finding the Right Path
In my previous article, I managed to get some really crazy performances in tree processing by using PostgreSQL recursive procedural-style function.
- Recursive Hierarchical Queries in SQL: A Deep Dive into Employee Level
- Which Way .NET Developer?
-
Recursion with PostgreSQL, Follup 1, Perfomances
I wrote a follow-up on yesterday's article on tree processing and recursion with PostgreSQL. This one: https://github.com/vb-consulting/blog/discussions/1
SQL was never intended for this kind of stuff; I'm sure that Fabian Pascal will tell us all about it.
And indeed, recursive CTEs are awful, confusing, and severely limited ... but they look cool and smart, and smart people use them (I hate them).
In any case, I used a procedural approach to this problem and, with a few smart optimizations, managed to squeeze some really spectacular performances (757K tree records with 20K unique nodes in just 5 seconds without any indexes, so it probably can go even faster).
What are some alternatives?
computer-architecture-and-systems-resources - A curated list of Computer Architecture and Systems resources
Logidze - Database changes log for Rails
jak-project - Reviving the language that brought us the Jak & Daxter Series
pgkit - Pgkit - Backup, PITR and recovery management made easy
Kaiserreich-4-Bug-Reports - Issue tracker for Kaiserreich for Hearts of Iron 4
developer-handbook - An opinionated guide on how to become a professional Web/Mobile App Developer.
PRP-6502 - Breadboard computer / CPU -- 6502 based
aquameta - Web development platform built entirely in PostgreSQL
kaiserreich - Issue tracker for Kaiserreich for Hearts of Iron 4 [Moved to: https://github.com/Kaiserreich/Kaiserreich-4]
pgreplay - pgreplay reads a PostgreSQL log file (*not* a WAL file), extracts the SQL statements and executes them in the same order and relative time against a PostgreSQL database cluster.
cider-i18n - Cider l18n translations powered by Crowdin for use with Cider Collective products.
RssDotnet - A list of my favourite dotnet RSS feeds