hæx.com logo

Fix for Heap exhaustion while migrate mysql to postgres

2024-03-30 by

Ran into multiple issues while migrating a mysql DB to postgres. Errors like

Heap exhausted during garbage collection: 352 bytes available, 416 requested.

I tried allocating more memory everywhere, but in in the end the prefetch rows finally worked for me

Example migrating mysql to postgres with prefetch:

pgloader --with "prefetch rows = 10000" mysql://user:password@127.0.0.1/dbname postgresql://user:password@127.0.0.1/dbname

Regarding Meta/Facebook account

2024-03-26 by

I don't understand Facebook. I left Meta long time ago, and whenever I try to use their services, because people wants to connect, it just roadblocks me all the way 🤦

Anyways; Twitter/X, Mastodon, Twitch, Discord, Slack, Telegram, Snap, Signal, Email, SMS etc are all useful services 🙂

Sorry for giving you another chance, Meta 🤦

The world I want to live in

2024-03-24 by

A list of thoughts and ideas for a fun future, WIP.

  • All information is always available and cleary cited
  • Every human understands that all beings are different, and everyone's need is different. Empathy
  • Maximum synergy amongst human beings
  • Humans understand that the internet is full of bots and how they work
  • Everyone is connected at will. World Mobile/Starlink/Telecom comes to mind
  • "You do you" and that's okay
  • Digital sovereignty is solved, maybe by Atala PRISM or solid project
  • Gigabit bandwidth everywhere, minimum. Hardware and software
  • There's no fuelling/charging a car. The battery just gets swapped out with a freshly charged one, and the car drives on, adding the depleted battery to the charging network
  • Ærlighet varer lengst
  • When you buy something, you own it and may do as you want with it as seem fit. Within laws
  • Goods are available where needed. Logistics problem. (3D-printing a cake, medicines by drone etc)
  • Global economic fundamentals are based on open-source and rigorous new technology like blockchain, e.g. Cardano, usage will of course vary by location
  • Health priority
  • Proactive health services; We have the tech, it's possible to create systems where you can be your own doctor
  • Human creativity is paramount
  • Greed is bad
  • Consciousness is explained and understood
  • Theory of everything exists within physics
  • International/Global open AI Safety protocols
  • Usage of technology to avoid corruption, in all disciplines
  • The idea of War is dumb and frowned upon / makes no sense
  • VR gaming is solved, Valve shows the world how it's done. Floor tiling is consumer product for infinite movement
  • All humans are content
  • systems/software/information sharing is made through formal methods / pure programming / open specifications, and can be verified by anyone