News Articles database

How to compute the Betweenness Centrality against Nebula Graph

​Betweenness Centrality (BC for short) reflects the significance of vertices in the entire network. This article will introduce how to compute Betweenness Centrality against Nebula Graph. Relevant Concepts Centrality represents how central a vertex is in the entire network graph, including Degree Centrality, Closeness Centrality, and Betweenness Centrality, etc. Degree Centrality reflects the popularity of […]

How to build AdonisJS API to store your Raspberry Pi Temperature

Introduction I have a few Raspberry Pi devices at home and I wanted to be able to collect the data from their temperature sensors on a regular interval and store that data in a Postgres database. Later on, I could use that data for some analytics together with Materialize. In this tutorial we will use […]

CouchDB clients in Javascript

Apache CouchDB is an open source NoSQL document database that collects and stores data in JSON-based document formats. Since CouchDB makes use of HTTP protocol, therefore we can use any HTTP client to connect with CouchDB. However, there are some existing CouchDB client libraries that are very easy and convenience to use. Below I would […]

How we upload File with some data to nodeJS using Simple Form

Configuration first you have to install some libraray to your to your project npm i express multer mongoose index.js app.use(express.static(__dirname(‘/public’)) //set folder as static folder app.use(express.urlencoded({extended:false})) //set req.body of data are accessible from index.html <form action=”/api/post” method=”post” enctype=”multipart/form-data” > <input type=”text” name=”name”/> <input type=”email” name=”email”/> <input type=”file” name=”file” id=”file” /> <nput type=”submit” /> </form> index.js […]

Learn SQL: Microsoft SQL Server – Episode 12: Finding the length of a String

Many times we have to look at how many characters there are in a string. Sometimes we even need to find the position of a character or a set of characters in a particular string in a column. In this episode, we will look at how we can accomplish this very exercise. In SMSS, for […]

How did we tackle Airtable's API limits at FINN?

We started to use Airtable at the early stages as I described in my previous article. Today, you will be reading how we tackled Airtable‘s API limits while the company grows to 10.000 car subscribers since 2019. (Andreas Wixler (CTO) initiated the Slack channel for Airtable Action Squad) After we hit the limit, we were […]

How to Install and Use Materialize to Run SQL Queries on your nginx Logs

In this tutorial, I will show you how Materialize works by using it to run SQL queries on continuously produced nginx logs. By the end of the tutorial, you will Read All Source: Hacker Noon – Programming

What is the difference between Amazon RDS Read Replicas vs Multi AZ

What is Relational Database Service (RDS) Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups. It frees you to focus on your applications […]

Reduzindo as chances de errar um squash de migrações no Hasura

Sumário Versão das tecnologias Requisitos mínimos de conhecimento para entender o artigo Por quê deste artigo Para os apressados Exemplo de base de dados Processo de fazer um squash Conclusão Versão das tecnologias Hasura v2.0.9 Hasura CLI v2.0.9 PostgreSQL 12 Requisitos mínimos de conhecimento para entender o artigo Entender de comandos SQL Como migrações funcionam […]

Migrating to Snowflake, Redshift, or BigQuery? Use Datafold to Avoid these Common Pitfalls

The Drive to Migrate Data to the Cloud With data being valued more than oil in recent years, many organizations feel the pressure to become innovative and cost-effective when it comes to consolidating, storing, and using data. Although most enterprises are aware of big data opportunities, their existing infrastructure isn’t always capable of handling massive […]

Nothing renders in React TS app using DB

In my TS React app nothing renders (ReactDOM.render is called in a different file) App.tsx: import * as React from ‘react’; import ‘./App.css’; import name from ‘./db/db’; const App = () => { return ( <main> <h2>Chat App</h2> <p>hello {name}</p> </main> ); } export default App; db/db.ts: import Client from ‘@replit/database’; const db = new […]

String Operations On Phone Numbers In SQL

When dealing with SQL databases, users will have to interact with different data types and schemas depending on the project’s requirements. Since databases are used in many different applications and support multiple platforms, devices, and users, there may be differences in how data is entered, even in a simple field like a phone number. For […]

It's Prisma Time – Introduction

Hi Folks 👋 and welcome back, Today I want to start a new series about Prisma. But before starting I want to explain the reason why of this series. In the last months I spent more time using ORM in the node eco-system. Most of the time I used typeorm. In my opinion Typeorm is […]

Using PostgreSQL in Rails

In this article, we will implement PostgreSQL into our Rails application. By the end, your rails application will have been configured to create its databases using the PostgreSQL adapter. This article is for anyone who has some experience with Ruby on Rails. We will complete the following tasks: — Create a PostgreSQL user and password in […]

MongoDB $weeklyUpdate (December 13, 2021): Latest MongoDB Tutorials, Events, Podcasts, & Streams!

👋 Hi everyone! Welcome to MongoDB $weeklyUpdate! Here, you’ll find the latest developer tutorials, upcoming official MongoDB events, and get a heads up on our latest Twitch streams and podcast, curated by Adrienne Tacke. 📢 This will be the last $weeklyUpdate of 2021! We’ll be back after the New Year in 2022. Stay safe, healthy, […]

Your Go-To Rails Command Line Cheat Sheet!

I’ve been learning Rails and working in backend development environments for the last few weeks through my coursework at Flatiron school, and I’ve found there are some commands used more frequently than others when building out Rails applications. I thought it would be beneficial to myself as well as others to create a ‘cheat sheet’ […]

Breaking Up a Monolithic Database with Kong

There are events in our life that seem to be just routine, but then unexpectedly they have a profound impact on our journey. For me, one event was attending the 2008 Gartner conference in Orlando, Florida. That event not only introduced me to the Salesforce ecosystem for the very first time but also to concepts […]

GET request with nested query REST API

From my MongoDB database, I am querying data. For this, in my backend, I am getting the data by this, const products = await Product.find({ ‘backCamera.sensor.megaPixels’: { $gte: 8 } }) How I can send a GET request from the front end to meet this query? I’ve tried this way but didn’t work fetch(‘http://localhost:5000/api/v1/products?backCamera.sensor.megaPixels=12’) .then(response […]

Sitemap | Terms | Privacy | Cookies | Advertising

Senior Software Developer

Creator of @LzoMedia I am a backend software developer based in London who likes beautiful code and has an adherence to standards & love's open-source.