Categories
Raspberry Pi User Help

24/7 Solar panel + battery to power a Raspberry Pi Zero W

I need to create a system to have a remote bees monitoring. In this place I haven’t the electrical energy. Basically I need to monitor some sensors (5 temperature and humidity sensors). I’m not expert electronic side (I’m a sw developer) and I would like to understand if it’s possible (or already exist) a way […]

Categories
User Help Web Pro

How do I configure the available memory in my PHP-FPM pools?

I have 20 GB available for PHP-FPM on my server, the average consumption of my PHP-FPM pools is 55 MB. I want to create a www.conf for the site and a www2.conf for routines that run during the day. I was wondering if I should configure the two files, considering 20 GB of memory, in […]

Categories
Bitcoin Cryptocurrency Mastering Development

What do you think about Poloniex?

If you want to know all about cryptocurrencies and exchanges, for example, Poloniex, I have a good source about it and how to make big money on cryptocurrency https://cryptograph.life/reviews/exchanges/birzha-kriptovalyut-poloniex-poloniks-registraciya-kak-torgovat-otzyvy-obzor

Categories
Cryptocurrency Ethereum Mastering Development

calculating ethereum mining historical

meanwhile i’m in despair and don’t understand how some values ​​are used for the calculation. I sincerely ask for support on how I can calculate the amount of ethereum mined per day from historical data based on my hashrate. the formula: (((hashrateMH/s x 1000000) x BlockReward) / BlockDifficulty) x 3600 x 24 Example for 01/26/2021 […]

Categories
Mastering Development

SQL Queries in VBA Macros on Open Excel Workbook

Apologies for being vague, as I’m trying my best to explain the problem I’m facing. I’m having problems with Excel macros that I’ve written that perform SQL queries on open Excel workbooks using a DAO recordset. These procedures tend to query a worksheet based table (on Sheet1), copy the output of the query to another […]

Categories
Mastering Development System & Network

Elasticsearch – does compression affect shard sizing calculations?

I was reading about elasticsearch shard sizing at: https://www.elastic.co/blog/how-many-shards-should-i-have-in-my-elasticsearch-cluster In the article, they write a few tips in regards of the shard size for example: TIP: Small shards result in small segments, which increases overhead. Aim to keep the average shard size between at least a few GB and a few tens of GB. For […]

Categories
Mastering Development

How to find a distance between elements in numpy array?

For example, I have such array z: array([1, 0, 1, 0, 0, 0, 1, 0, 0, 1]) How to find a distances between two successive 1s in this array? (measured in the numbers of 0s) For example, in the z array, such distances are: [1, 3, 2] I have such code for it: distances = […]

Categories
User Help Web Apps

In Facebook is there a way to add someone to a friend list before they accept your friend request?

If you go to someone’s profile page and add them as a friend, while it’s still pending, is there a way to add them to a list? Or do you have to wait for them to actually accept your friend request so that you can, for example, restrict them from viewing certain posts of yours?

Categories
User Help Web Apps

How do I highlight a cell based on time?

For example, I want to have a cell highlighted while an employee is on break. So for this I have an "OUT" time and an "IN" time. If the employee goes on break at 14:22 and is back at 14:37, I want 14:37 to be highlighted red until that person is due back.

Categories
Database Development

How to separate a number from 3 digits to 3 digits by comma in sql server?

For example, I want to convert the number. select convert(1354256,money) salMoney result: 1354256 convert to 1,354,256