It's a shit ... Worst than a raspberry ... But it's my shit ... I did not have a screen to install so i used the 14" tv ..

Two hardrives?

Two hardrives?

yeah ... the small one is from a toshiba laptop 500 gb for system and data backups and another 500 gb will be filled with music to make a personal stream radio

With MPD?

but i'm preparing the environment because openbsd have some differences and i must make some changes

My plan is to make a Plex server

nice ... hope you have more time than me ...my job steal me a lot of time right now and i go steeeep by steeeep too slow

the job, the girl, the dog plus the time i spend in sleep and eat ... so free time for my own = almost nothing

My plan is to make a Plex server

I am running Plex on freebsd

Yes..but first I need to make the case.

Yes..but first I need to make the case.

I dare you .... I double dare you I hope you make that case

Lol...I supposed to do it this weekend. But my lazyass rather watch movies all day.

Also I'm not going to build from scratch like Carl did, I'm looking for something that can fit the parts.

Lol...I supposed to do it this weekend. But my lazyass rather watch movies all day.

i wish i could watch movies all day instead i'm studying for my upcoming exams all day

Hi, wich is the fastest db ? (to use with php). I was wondering if awk is good choice ? But in my database I want also to store some bytes (then i dont think it's good for this purpose)

What is the use case?

Without that we cannot give any suggestion.

Caching with key value I would say redis. But if you need relations obviously not. Then something more sql based like postgresql. Also depends on the architecture of your application. Distributed? Cassandra maybe or replicated/sharded mariadb... So many options

But reading your question tells me that you did not think about these things as you do it as a hobby. In that case I would suggest picking the one you favor and would like to learn :)

For the moment I have'nt already fixed in my mind the type of architecture

But the main use case is reading fast in multi rows (there will be a small number of columns about 2)

What is the data that you will store?

Do you need more tables than one?

3 tables

Could you store the object simply in JSON?

only strings

Do you need to persist or is it for runtime only?

no I need to persist

I see. How do the tables differ? Is there any relation between them? Do you work with foreign keys?

only for one table where the structure is 3 columns : first strings and second strings and third bytes

yes I need a foreign key

only one to connect users

Interesting usecase. May I ask why you want to persist binary?

cause I want to store messagePack datas

which works like JSON

but it's smaller

Ah protobuf alternative

due to the conversion in binary mode

In that case I would go with Postgres (easy expansion in the future, simple to setup)... MongoDB would be a little overkill for my taste but what would also work is Redis with FS persistence. Allows you to persist binary and offers more than a simple key value store. The choice is up to you

Postgres may be a little more work initially compared to redis with FS

Are they fast in read mode ?

Indeed.

For reading almost every database is as fast as you could think

How long do you intend to store the data? Maybe your Architecture is suited for eventing?

I though for long term storing at least more than a year

thanks for your time and expertise

I though for long term storing at least more than a year

Then i would personally go with Postgres

And you're welcome :)

the syncthing daemon is eating up over 100% cpu usage is that normal?

ok now just about 20-30%

Mh so i tried adding temporary directories to the ignore list I hope that helps

hello everyone

Hi

Can someone tell me how I can upgrade my whole ports ?

ok i now did portmaster -af

portsnap fetch update

Yes i did that before

But it just fetches the latest ports

Hi there, Can QEMU/KVM be installed on FreeBSD 12.1 without any problems?

I ask because VirtualBox seem to be "broken".

I need to set up a few virtual machines on my server.

FreeBSD has native virtualization -> bhyve

Yes But it seems advanced for a FreeBSD noob like me... 😉

Can you recommend any good guides for bhyve?

Hi there, Can QEMU/KVM be installed on FreeBSD 12.1 without any problems?

Kvm is the kernel based virtual machine, its a module in the linux kernel so it's very unlikely available for BSD But you can use virtualbox, you can use qemu and you can use the bhyve hypervisor

Hi I want to use postgresql with FreeBSD, is the choice of filesystem will impact performances (see there https://wiki.postgresql.org/wiki/FreeBSD)

wich filesystem do you recomand for : UFS or ZFS ?

Hi I want to use postgresql with FreeBSD, is the choice of filesystem will impact performances (see there https://wiki.postgresql.org/wiki/FreeBSD)

of course the filesystem you choose will impact ur performance

i would go with ZFS

Thank you

Can you recommend any good guides for bhyve?

https://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/virtualization-host-bhyve.html

wich filesystem do you recomand for : UFS or ZFS ?

Ufs for performance, zfs for convenience

You may want to disable journalling, not sure if it will ease io load much

But dont trust guides which tells to turn off softupdates.

Ufs for performance, zfs for convenience

Is ufs performance really that much better than zfs ?

I'm going to install freebsd on an ssd on my laptop Should I really rather go with ufs than zfs ?

I know that if you use about 80% of the partition than ZFS will start to lag

Oh OK

I'm going to install freebsd on an ssd on my laptop Should I really rather go with ufs than zfs ?

Zfs is memory hungry (due to arc cache) and in general it is more complex meaning more slower