teleren/devto huggingface dataset:
The Ruby On Rails Interview Bible - Author Nezir Zahirović talks about his book
Tags: books, promotion, ruby, friendlyshow
Published: 2023-06-23 12:03:46

Hy guys, I had pleasure to be invited on the best #ruby #podcast out there. [Yaroslav](https://twitter.com/yarotheslav) & [Adrian](https://twitter.com/adrianthedev) doing really nice work for community. If you are rubyst I think I dont need to introduce those two gems! 

"Today we speak with [Nezir Zahirović](https://twitter.com/nezirzahirovic), author of The Ruby On Rails Interview Bible, about how his first contact with technology and how he got started with development, about the tools he used, and more importantly about a few ideas of what to do to stand out in your future job applications."

Please check the #podcast on the link [HERE](https://friendly.show/episodes/the-ruby-on-rails-interview-bible-author-nezir-zahirovic-talks-about-his-book)
Query Processing in PostgreSQL
Tags: bitnine, apacheage, postgres, postgressql
Published: 2023-06-23 12:02:45

Query processing ins **PostgreSQL** is the most complicated system and it efficiently processes the supported SQL. In this article, we will look at query processing, in particular focusing on query optimising.


In postgreSQL, a parallel query implemented in _version 9.6_ uses multiple background worker processes, all queried issued by a connected client are handled by a backend process. This backend process consists of five subsystems as shown below. 

- **Parser**
This helps to generate a parse tree from the SQL statements that were written in plain text.
The root node of this parse tree is the _SelectStmt_ structure that is defined in the _parsenodes.h_. The SELECT query and the corresponding elements of the parse tree have the same numbering. Since the parser only checks the input syntax when generating the parse tree, it only generates an error when there is a syntax error in the query.




- **Analyser**
Semantic analysis of the parse tree is carried out and a query tree is generated.
The _query_ structure defined in the _parsenodes.h_ is the root of the query tree. This structure also includes the metadata of its corresponding query. A query tree includes things such as a _targetlist_ which is a list of columns that are the result of the query. The join tree saves the FROM clause and the WHERE clauses.






- **Rewriter**
Given that such rules exist, the rewriter uses the rule system to transform the query tree.
The rewriter has a system that generates the rule system. It looks at the rules stored in the _pg_rules_ system catalog and rewrites the query tree. The rule system itself is quite intriguing but we will omitt it from our short summary to prevent it from becoming too long.







- **Planner**
The plan tree that can most effectively be executed from the query tree is generated by the planner.
The planner in the PostgreSQL is a purely cost-based optimisation system and it doesn't support rule based optimisation and hints. Consequently, this planner is the most complicated system in an RDBMS. A plan tree consists of elements called _plan nodes_ and is connected to the _plantree_ list. Each of the plan tree consists of information that the executor requires for processing.


- **Executor**
This executes the query by accessing the tables and indices that were created by the plan tree in order.
The executor reads and writes indexes and tables in the database cluster with the help of the buffer manager that will be further described in upcoming summaries. The executor occupies some memory areas, line the _temp_buffers_ and _work_mem_ are allocated in advance and temporary files are created if necessary.
Facebook Conversion API: 4 Tips To Maximize Business For Small Businesses And Startups
Tags: facebook, conversionsapi, metacapi, facebookcapi
Published: 2023-06-23 12:01:04

What is Facebook Conversions API?

How can it be useful for Startups?

How does it track everything?

Know answers of all your questions with this blog:


https://www.conversios.io/blog/facebook-conversion-api-for-startups/
Who's looking for open source contributors? (week 47)
Tags: discuss, opensource, contributorswanted, codenewbie
Published: 2023-06-23 12:00:00

---
title: Who's looking for open source contributors? (week 47)
series: Looking for Contributors
published: true
description: Discover which open source projects are actively seeking contributors. Learn how you can make a meaningful contribution to the open source community and gain valuable experience. Find out who's looking for open source contributors now.
tags: discuss, opensource, contributorswanted, codenewbie
# cover_image: https://direct_url_to_image.jpg
# Use a ratio of 100:42 for best results.
published_at: 2023-06-23 12:00 +0000
---
Open Source is about the community. Whether you have a project or you're looking to make your first PR, we want to help facilitate those connections. 

## Tell us about your project
_Promote your project by providing a link to the repo. Everyone who posted in previous weeks is welcome back this week, as always 😄_

Open Source should be a welcoming space for contributors. The README is the front door of your project. If you'd like to check out an example of a README, here's our [OpenSauced/insights README](https://github.com/open-sauced/insights).

If you submit please have the following in your repo to make it welcoming and helpful for contributors:

1. README.md
2. CONTRIBUTING.md

Feel free to drop your issues and repos in the [OpenSauced Discord](https://discord.gg/opensauced) #:eyes:-looking-for-contributors channel at any time! 

If you're new to open source, and you're not sure where to start, check out our [Intro to Open Source course](https://github.com/open-sauced/intro). 

Finally, consider reading the [Best Practices for Maintainers](https://opensource.guide/best-practices/).

Just a note to say, we've restarted this post from something Ben was doing for a while :star-struck: 

Happy coding!
How Analytics And Marketing Pixels Can Benefit Your Ecommerce Business
Tags: analytics, pixel, ecommerce, business
Published: 2023-06-23 11:57:04

Analytics or Marketing Pixels?

What do you think is more beneficial for Ecommerce Business?

Are they even useful for your business?

Know everything about it with the help of our latest blog:


https://www.conversios.io/blog/analytics-and-marketing-pixels-benefits-for-ecommerce-business/
How to Quickly Setup Java Microservice Projects?
Published: 2023-06-23 11:53:32

When We start Development, Team often spends a significant amount of time in project setup work and developing mechanisms to handle cross-cutting concerns. 

Cross cutting concerns like 

1. Externalized configuration - includes credentials, and network locations of external services such as databases and message brokers
2. Logging - configuring of a logging framework such as log4j or logback
3. Health check - a url that a monitoring service can “ping” to determine the health of the application
6. Security - for example, REST APIs must be secured by requiring an Access Token

It is typical to dedicate one to two days, occasionally even more, to setup the project and putting cross-cutting concerns as the initial investment is negligible if you plan to spend months or years developing a monolithic application. 

However, if you are creating an application using a microservice architecture, the scenario is entirely different. Tens or even hundreds of services are available. You'll regularly design new services, and it will only take a few days or weeks to complete each one. You can't afford to take several days to set up each service.



Question: How to Quickly Setup Microservice Projects? 

Answer:
**Microservice chassis pattern
**

Create a microservice chassis framework that can be foundation for developing your microservices.
The chassis implements Reusable build logic that builds and tests a service. This includes, for example, Gradle Plugins.
Mechanisms that handle cross-cutting concerns. The chassis typically assembles and configures a collection of frameworks and libraries that implement this functionality.

There are well developed Java microservice chassis available to use like Spring Boot, Spring Cloud and Drop Wizard.


The fundamental advantage of a microservice chassis is that updating dependencies, build logic, and cross-cutting concern logic is quicker and simpler. You only update each service to use the latest version of the microservice chassis framework, which has been updated to include the necessary changes.

One issue is that each programming language or framework you want to use has its own microservice chassis. Adopting a new programming language or framework may be difficult because of this.
How To Setup Meta Pixel For Your Shopify Store
Tags: wordpress, shopify, metapixel, facebook
Published: 2023-06-23 11:12:25

Setup Meta Pixel For Your Shopify Store with the help of a single click

Learn integration with this brief guide and track everything you want to know! 

https://www.conversios.io/blog/setup-facebook-conversion-api-for-woocommerce/
Nodejs blog
Tags: webdev, javascript, node, express
Published: 2023-06-23 11:09:40

Few weeks ago I started to learn backend web development using nodejs.After finishing a beginners course, I decided to test what I have learnt and so I made this blog application.Also, I made the frontend using html, css, sass and javascript.
All the documentation and script comments are in Spanish.

Here are the links:
- [backend github repo](https://github.com/LopCuns/nodejsblogbylopcuns)
- [frontend github repo](https://github.com/LopCuns/nodejsblog__FRONT)
- [website](https://jlblog78.netlify.app/)
ChatGPT: Should Software Developers Worry about AI Taking over their Jobs?
Published: 2023-06-23 11:07:18

"Software engineering is a dying profession," a Microsoft engineer wrote in a Blind post in April, 2023 titled "Face it, the golden age is over." There is a growing concern over the possibility of AI taking over Software Development but I strongly disagree that this will ever happen. In my opinion, software developers should be excited about the new possibilities and capabilities that AI offers.

When I started teaching myself how to build websites in 2018 with HTML, CSS, and JavaScript, it was exciting and challenging. One of the courses I bought on Udemy introduced me to Stackoverflow, which became my favorite place to seek help,  anytime I got stuck. Today, I haven’t visited Stackoverflow for the past three months. ChatGPT, and Google Bard have since taken up that role. Oftentimes, I wonder how it was possible to code without ChatGPT.

Software developers should not worry about AI taking over their source of livelihood, however, they should be concerned about the effects it is having and will continue to have, they should monitor and pay close attention as things will obviously not remain the same. 

Big salaries and entry-level positions have already been affected. Five years ago, beginner knowledge in HTML, CSS, and JavaScript alone was sufficient to land you a high paying job; today it is nearly impossible. Your best bet as a beginner will be to go beyond the basics. The industry is not open to beginners any more. You need to master at least one programming language and also master a popular framework or library in that language to be on the safe side.

There has been a massive layoff from Tech behemoths like Twitter, Meta, Google, etc. in recent times, this might not be unconnected with AI. Regardless, one thing is certain, the times are changing and will continue to change even faster. Developers shouldn’t be asleep, they should monitor these changes and adjust accordingly. 

Ushahemba Shir.
Senior JavaScript Developer.
http://usha.com.ng/

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/83689ih1b0dehe65cvoc.jpeg)
Cara hilangkan CR LF DI NOTEPAD ++
Published: 2023-06-23 10:29:28

jadi udah berapa minggu terakhir kepencet ga sengaja atau apalah  bgst ini notepad++ gue jadi kyk begituan tampilan nya


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ujua01a1mn0mffcnscpc.png)

ada **CR LF** lama lama gatel juga nih mata liat nya.

gue cari2 akhir nya ada juga tutorial fix nya :v 
nih gue share :

klik view -> show symbol -> show all characters di klik aja hapus centang nya!

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/uu65ows6fdspjhh5az5g.png)
voilaa !!


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/gazzewhsb8umi7x6y2bl.png)

beres deh itu..
ciao!
How to Create Web app in Azure Using Azure cli
Published: 2023-06-23 10:24:34

The blog post is about using Azure cli commands to create web application
a.	Open powershell terminal and login using  “az login”, you will be directed to a web browser to sign in. after that use the following commands to create:-
b.	Create the resource group using the command below, after doing az login in your powershell: AppServiceRG 
az group create --name AppServiceRG --location eastus.


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hafh8njfekroe03emj5c.png)
c.	Create an app plan using the command: appservicePlan
az appservice plan create --name appservicePlan --resource-group appServiceRG

 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/2ep5eip3qa2det5i2tue.png)



d.	Create a web app using this command: Project10WebApp
az webapp create --name Project10WebApp --resource-group AppServiceRG --plan AppServicePlan

 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6irghoehv90pd7gfjls6.png)



e.	Go to the azure portal to confirm that you have successfully created your resource group: AppServiceRG, web plan: AppServicePlan and the web app: Project10WebApp. 

  
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/vifl6b3jbz0ky3y2v8fg.png)



Under the app plan we can see CPU, Memory. Data in/out, region, instance size, scale count, SKU/Pricing tier this shows the app plan does the computing work of a VM.
 


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/bhwglz4ax6fk1vcon4a4.png)
How to use Enhanced Inventory Receiving on Transactions in QuickBooks Enterprise?
Published: 2023-06-23 09:59:17

Enhanced inventory receiving in QuickBooks is one of the best features and is known to manage the completely new procedures of paying and receiving the items. Moreover, it is one of the best features accessible in QuickBooks, as it changes past transactions when started. This particular feature manages the completely new process for receiving and paying the items. One can try to use the enhanced inventory receiving on transactions in QuickBooks enterprise using the steps below. Thus, make sure to read this post till the end. Or you can also consult our tech support professionals at QuickBooks payroll customer service  and we will provide you with instant support services. 
What happens after turning on EIR?
•	The bills do not increase the inventory items and also the bills that are generated from the items receipts no longer exchange items receipts. 
•	Furthermore, the accounts payable doesn’t get affected by the item’s receipts. 
•	The third-party applications that affect the inventory may not be able to work along with the EIR. 
•	Moreover, after the user turns on the EIR, the process generates receipts for each bill in the company file that carries items and thereby there is growth in the number of the transactions. 
Steps to activate the enhanced inventory receiving feature
The user can try to activate the enhanced inventory receiving feature using the set of steps below:
•	The very first step is to choose the edit menu 
•	After that click on the select item and inventory 
•	Once done with that, on the company preference tab, the user is supposed to click on enable below enhanced inventory receiving section. 
•	Also, the user will now get a warning message and he/she has to click on continue. 
•	The user will see a pop-up message that would ask for back up the company file. 
•	This might take some time due to the size of the company file. 
•	QuickBooks desktop will generate the review of all the modification that happened during the process. 

Read Also:[QuickBooks accountant desktop ](https://www.hostdocket.com/update-quickbooks-desktop-to-the-latest-release/
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/iccwyi12pcwc1z39xuts.jpg))

By the end of this post, we believe that the user might be able to learn the steps to use enhanced inventory receiving on transactions in QuickBooks enterprise. Just in case you have any sort of queries or if you require professional guidance at any point in time, then in that case contacting our tech support professionals at QuickBooks payroll customer service is recommended. We are a team of certified QuickBooks professionals who work round the clock in providing immediate support services +1-844-405-0907.
Go and C, friends forever?
Tags: go, cpp
Published: 2023-06-23 09:49:23

As there are no actively maintained complete sip stack in Go, and most development seems to have died years ago, I had started to adapt libeXosip2 for use with Go.  Doing the more real-time side in pure C, which Go can directly call and wrap using cgo, and the squishy upper level logic in Go, can make sense to me. I could also see writing a RTP stack operating in pure C with it's own C threads, to call from Go in the same way.

The downside of wrapping C in Go is that really you need to convert everything to Go types and structs, especially to export them, and to do so efficiently, all the C wrapper code should really be together in one Go file, along with the C headers and stubs you make.  This is not a big deal for simpler C libs, and libeXosip2 mostly deals with int and string types, so that is not too bad, but it does have an event struct that has complicated internal C types.  A new Go event struct would have to be made, and all these internals converted, in the Go wrapper file, too.

In C++, I can just carry the libeXosip2 event struct as is, and decode parts of it in different places as needed. But C++ imposes different problems, so while I have a rather thin libeXosip2 wrapper in C++, complexity is scattered throughout the codebase. Other kinds of complexity of course include building C++ projects, and CMake introduces as many problems as it solves.

Structurally Go makes a lot of sense for server logic for the kinds of applications I do.  Event objects would move thru Go channels to different subsystems where they would be processed.  This is kind of what Coventry already does in C++ with a homemade micro-actor framework. Those that work with Ruby would recognize this as being like creating a domain specific language. A lot of code is required to "tame" cpp in this way.  I used to do this in GNU Common C++, and now use my own header-only C++ libs, as it's less work and much easier to use C++ type deduction when everything is header-only.  The common patterns I often use are already much more naturally expressed in Go as is. So Go offers, for me, a tradeoff between a maintaining a complex C wrapper or complex C++ language enhancements. The remaining server code feels simpler and easier to maintain in Go.
Upcoming webinar titled "Unveiling the Power of Cypress for End-to-End Testing"
Tags: cypress, testing, qa, eventsinyourcity
Published: 2023-06-23 09:47:34

Hello,

I hope this message finds you well. I am excited to extend a personal invitation to you for an upcoming webinar titled "Unveiling the Power of Cypress for End-to-End Testing" that I will be hosting on [22 July ] at [11 AM IST]. 

As a professional in the tech industry, I believe this event will provide valuable insights and enhance your understanding of Cypress, a powerful tool for end-to-end testing.

[Please register and Share in your circle ](https://bit.ly/3NC2vHZ)

I am looking forward to your presence and participation in this exciting webinar.
How To Query Ethereum Balances Using SQL and FlipsideCrypto
Tags: ethereum, blockchain, balances, flipsidecrypto
Published: 2023-06-23 09:44:32

---
title: How To Query Ethereum Balances Using SQL and FlipsideCrypto
published: true
description: Anybody can query blockchain for free.
tags: ethereum, blockchain,balances, flipsidecrypto
# cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wpd593qy7ecnqy8i6p2s.png
# Use a ratio of 100:42 for best results.
# published_at: 2023-06-23 09:37 +0000
---

I recently [published a post](https://trove.wtf/how-many-people-own-ethereum/) on how many people own [Ethereum](https://trove.wtf/a-beginners-guide-to-understanding-ethereum-blockchain/) (ETH), the cryptocurrency that has revolutionized how the world sees money, and broken the geo-political borders of international finance. I supported the post with recent blockchain data which indicates that over 84.2 million people own more than `0.0001ETH`. 

Now, I wish to describe to the process I went through to get such blockchain data to back the post, and how anybody can also query blockchain for free using FlipsideCrypto and some knowledge of SQL.

### Pre-erequisites
I assume you have a computer with regular internet connection to start with. And you'll need some basic knowledge of SQL to begin with, but if you don't, that's fine. You can copy the code and follow along for the meantime. 

### FlipsideCrypto
We'll be using flipsidecrypto's studio to query the blockchain information so let's head to htts://flipsidecrypto.xyz. Flipside is a blockchain data provider that gives access to multiple blockchains (20+) at no cost, and their studio is just like a Jupiter Notebook but for blockchains. 

Now, create an account on Flipside, comfirm your email, click on "studio" and let's get started with the code.
![Acces FlipsideCrypto studio](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/1y3tcklh0i3ovhq477wc.png)

### Ethereum Holders
Now, once inside the studio, paste this code block inside the ext editor and click on run at the upper-right corner of the dashboard.
```
select
  count(distinct user_address) as holders
from ethereum.core.ez_current_balances
where symbol = 'ETH'
  and contract_address is null 
  and current_bal >= 0.0001
```

So this is what the code does. It selects every unique wallet address from the `ethereum.core.ez_current_balances` table, where the symbol of the currency is `ETH`, the `contract_address` is `null`, and the balance is greater than or equal to `0.0001ETH`. This is to make sure that only genuine ETH holders are counted, and users with very tiny balances are left out. After executing the script, you should see the results in the right pane. 
![Results](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/86cdmwh1ltym9zf53gf5.png)

That is all for querying Ethereum user balances using FlipsideCrypto and SQL, you can definitely play around with the query and checkout other supported tables you can play with on the left side of the studio. Have fun!