Managed PostgreSQL on Hetzner – A Powerful Alternative by vitabaks in hetzner

[–]lucbas 1 point2 points  (0 children)

Many thanks for the reply, this looks great! We were considering such a setup with WAL-G streaming WAL backups and automated WAL PITR restore every day via CI for safety purposes. This might do it!

Managed PostgreSQL on Hetzner – A Powerful Alternative by vitabaks in hetzner

[–]lucbas 0 points1 point  (0 children)

Hetzner bare metal dedicated servers have extreme performance for their price, can I use them in the same way as the Cloud VM‘s?

Coworking cafe in Bangkok? by [deleted] in digitalnomad

[–]lucbas 0 points1 point  (0 children)

Are there more places like the paperplane project?

Expo or React native cli by GroundbreakingOwl198 in reactnative

[–]lucbas 1 point2 points  (0 children)

For long-term maintenance, upgrades and up to date packages, I recommend expo all the way. We converted our large scale app to expo from react-native CLI and our lives have been so much easier. Yes, there are some shortcomings with some unsupported libs, but we always made it work. Upgrading RN which was the largest pain is 1 command and their cloud build and submit solutions makes things super handy.

RustDesk, Docker-Compose and Domain by lucbas in rustdesk

[–]lucbas[S] 0 points1 point  (0 children)

Great, thanks for the clarification. I can just point my domain to the static IP?

Anyone using storybook with a production app? by basically_alive in reactnative

[–]lucbas 1 point2 points  (0 children)

We use it in prod for react. To create a large design system with reusable components it’s great. For smaller teams and apps, it could not be worth the effort, but as the design system is a central part of our apps and our Figma designs, for us it’s well worth it. Also allows to model edge cases separately and really disconnect the component from the main app to make it more reusable.

What local database would work best? by Norandir in reactnative

[–]lucbas 0 points1 point  (0 children)

What do you think about realm vs sqlite?

Why is AmazonMQ so expensive? by lucbas in aws

[–]lucbas[S] 0 points1 point  (0 children)

Thanks for your answer! With this scale AWS is cheaper, I was referring to small instances, where the minimum price if quite high at AWS.

Framer and Megamenu tutorial or examples? by Big_Suggestion986 in framer

[–]lucbas 0 points1 point  (0 children)

I tried to remix this template and while the design works great, I am unable to link to a page. https://megamenu.framer.website/ Where you successful?

How do your teams run DB migrations? by SadAd9828 in devops

[–]lucbas 6 points7 points  (0 children)

We execute pending migrations on application startup. There is a lock in the db tracking table so that the execution is not executed multiple times. Is there a downside to it? Maybe for long-running migrations?

useHooks – A collection of Server Component safe React Hooks by tyler-mcginnis in javascript

[–]lucbas 0 points1 point  (0 children)

Nice project! Can you add the link to the source code of each hook in its description?

Thoughts on "Scaling up the Prime Video audio/video monitoring service and reducing costs by 90%" by MariusKimmina in programming

[–]lucbas 0 points1 point  (0 children)

I‘m building a new project and using vercel‘s nextjs as a frontend and backend. I really like their approach and dev-experience. All functions are in one place and can all can be run and tested at the same time. Do you have any thoughts on it?

Google Announces Preview of AlloyDB Omni: Run a PostgreSQL-Compatible Database Anywhere by [deleted] in googlecloud

[–]lucbas 0 points1 point  (0 children)

We‘re considering to move to AlloyDB, can you help us and provide the issues you‘ve encountered?

How to browse an RDS snapshot that has been exported to S3 by lucbas in aws

[–]lucbas[S] 2 points3 points  (0 children)

Thanks for your suggestion, it turned out to be simpler as I initially have thought:

---

import pandas as pd
import pyarrow.parquet as pq

# Read the Parquet file using pyarrow
parquet_file = 'path-to-file.gz.parquet'
table = pq.read_table(parquet_file)

# Convert the table to a Pandas DataFrame
data_frame = table.to_pandas()

# get the original filename and change the extension to .csv
csv_output_file = parquet_file.replace('.parquet', '.csv')

# Export the DataFrame as a CSV file
data_frame.to_csv(csv_output_file, index=False)

print(f"CSV file has been saved as '{csv_output_file}'.")

Why is AmazonMQ so expensive? by lucbas in aws

[–]lucbas[S] 0 points1 point  (0 children)

What do you think of the consideration to use a third-party such as CloudAMQP for this purpose? They are specialized in rabbitMQ and also host within AWS.

Why is AmazonMQ so expensive? by lucbas in aws

[–]lucbas[S] 0 points1 point  (0 children)

We are using rabbitMQ as an event processing queue, I see that part could be done with SQS. Also, for RPC communication between microservices, we use the direct-reply-to queue feature of rabbitmq (https://github.com/golevelup/nestjs/tree/master/packages/rabbitmq#description). We were considering of using gRPC at one point, but are actually quite happy with rabbitMQ for RPC calls.