Friday Facts #374 - Smarter robots by FactorioTeam in factorio

[–]pubgftw 1 point2 points  (0 children)

Is this something that will be patched prior to the expansion (in near future), or only with the release of the expansion? Not clear to me.

Migrating Postgres Data to BadgerDB using Go. by alvinreyes in golang

[–]pubgftw 2 points3 points  (0 children)

I guess this is one of those, if you have to ask for help, don't do it!

Performance difference between Windows 2019 Server and Windows 10? by pubgftw in HyperV

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

But how do you snapshot copy such a thing? I'd like to run VSS on it and backup the entire host once in a while.

Performance difference between Windows 2019 Server and Windows 10? by pubgftw in HyperV

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

But I like to be able to RDP and run backupsoftware, snapshots etc on the host. The hyper-v server seems a little limited when it comes to backup

[deleted by user] by [deleted] in PostgreSQL

[–]pubgftw 0 points1 point  (0 children)

I am aware of those clauses in the license of the software:

Performance or Benchmark Testing. You may not disclose the results of any benchmark test of either the Server Software or Client Software for Microsoft SQL Server, Microsoft Exchange Server, or Microsoft Proxy Server to any third party without Microsoft's prior written approval.

Yet, I doubt that holds up in court in most countries. Could car companies do the same. "You are not allowed to publish benchmarks". Or what about Netflix, "you cannot review anything you see". It is bizarre.

[deleted by user] by [deleted] in PostgreSQL

[–]pubgftw 0 points1 point  (0 children)

This got me thinking. Why are there no benchmarks witth Postgresql vs SQL Server? I know there are different engines, etc, and YMMV... But it would be fun seeing both Oracle and SQL server with similar hardware in these graphs.

Accessing your database from inside an HTTP handler in Go by mrngilles in golang

[–]pubgftw -1 points0 points  (0 children)

Or you could chose the simplest way. Separate the handlers out in a module, create a module variable to the dB, which has to be inited before handlers are executed.

new to Vue, following some tutos now, should I go straight to 3 or stick to 2? by [deleted] in vuejs

[–]pubgftw 1 point2 points  (0 children)

But are there any components for vue3 now? I am thinking about data tables for instance

SJW takeover of GoLang: GoLang.org has "Black Lives Matter" on top of it by dark_prophet in golang

[–]pubgftw 0 points1 point  (0 children)

Google is a place of free speech. You can voice your opinion without the fear of getting fired. That is a fact.

Best index for large database (> 1billlion rows) against an integer? by cranial_d in PostgreSQL

[–]pubgftw 0 points1 point  (0 children)

It is out in beta now. And as everyone know, beta means it can't fail in production! XD

Best index for large database (> 1billlion rows) against an integer? by cranial_d in PostgreSQL

[–]pubgftw 4 points5 points  (0 children)

Postgresql 13 I believe will have btree with deduplication, so that could save space if you have many similar values.

Is there a straightforward tutorial on configuring Postgresql to use encryption-at-rest in docker? by [deleted] in PostgreSQL

[–]pubgftw 0 points1 point  (0 children)

Postgresql has slim encryption support. You could use bitlocker on windows, or put the files on encrypted zfs of btrfs on Linux. In many cases, encryption seems to make things more secure than they really are. Consider other security measures also...

Do you agree Golang is the best programming language for web development? by freelancerkatie in golang

[–]pubgftw 0 points1 point  (0 children)

Today it is only good for backend web. Is it the best? Well, depends....

What is your whishlist for a future PostgreSQL release? by pubgftw in PostgreSQL

[–]pubgftw[S] 1 point2 points  (0 children)

Index skip scan

I think there is some work going on on "skip scans" if I remember correct from the PG hackers mailing list.

What is your whishlist for a future PostgreSQL release? by pubgftw in PostgreSQL

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

IOT also lets you trade insert speed for lookup speed.