Preferences

krasznahorkai
Joined 21 karma

  1. I knew it would happen eventually! I've been waiting for his award. Long time fan. My favorite is War and War (Háború és háború) because the confusion of the world and the endless struggle of trying to be understood represented so well.
  2. When I see a new Framework product, such as their latest Intel CPU updates and now a third screen installment for the 13, I can't help but feel frustrated at the limited effort put into the development and maintenance of older models.

    I'm linking the threads on the 11th gen and 12th gen Intel BIOS updates. It takes years for an update to be made available, and then it has endless problems with the update itself or after.

    Nirav Patel writes from time to time they're gradually putting more effort into the maintenance of their older systems, but it doesn't instill confidence the older hardware will remain as well supported as alternatives.

    11th gen: https://community.frame.work/t/11th-gen-intel-core-bios-3-10... 12th gen: https://community.frame.work/t/12th-gen-intel-core-bios-3-08...

  3. Yes. In essence what most businesses do is create a record for any given state, so it enables analysts to see when something was created/modified/deleted indeed.

    Most business applications contain only the actual state of data, so by loading the data warehouse these changes can be saved and analyzed.

    The simplest implementation is that each record gets a start_datetime and end_datetime so you can see the changes over time or figure out when something was deleted. Other techniques like data vault enable businesses to get a complete historic view of any given point in time.

  4. For Data Warehousing purposes it's nice if source systems use soft deletion for easy detection of deleted rows since a certain point in time. I don't think the use-case is limited to undoing user deletions.

    If there is no soft deletion or audit table available, the alternative is to either 1) Select all the source primary keys to find out which no longer exist in the source but do exist in the data warehouse 2) If there is no primary key available, select the whole dateset for full row comparison

    Since in corporate settings data warehouses load at least once a day, you can imagine the amounts of data being moved around needlessly.

  5. I work as a solution architect at a consulting firm that builds analytical data platforms for customers. Our company has a partnership with Snowflake, which means all the solutions we build are pushed to use Snowflake. Their sales strategy is very Oracle-like and at least in my circles many Snowflake sales employees are ex-Oracle. This means our sales and Snowflake sales are the best of friends. Formally they'll deny kickbacks, but who knows?

    For all my clients Snowflake is overkill when you look from the perspective of growth and scale. They'll never use that part of Snowflake. They might just do as well with DuckDB, Azure Synapse or any other analytical-oriented platform laying around.

    What I do like with less-than-big use-cases is that (at least at Snowflake) you pay relatively little if you do relatively little data processing. It's not free, but it doesn't break the bank either.

This user hasn’t submitted anything.

Keyboard Shortcuts

Story Lists

j
Next story
k
Previous story
Shift+j
Last story
Shift+k
First story
o Enter
Go to story URL
c
Go to comments
u
Go to author

Navigation

Shift+t
Go to top stories
Shift+n
Go to new stories
Shift+b
Go to best stories
Shift+a
Go to Ask HN
Shift+s
Go to Show HN

Miscellaneous

?
Show this modal