How-Tos

How to create AI agents with Neo4j Aura Agent

Neo4j Aura Agent is an end-to-end platform for creating agents, connecting them to knowledge graphs, and deploying to production using low-code and autogeneration tools. Let’s dive in.

By Zach Blumenfeld

Mar 19, 202610 mins

DatabasesDevelopment ToolsGenerative AI

How to merge data in R using R merge, dplyr, or data.table

See how to join two data sets by one or more common columns using base R’s merge function, dplyr join functions, and the speedy data.table package.

By Sharon Machlis

Feb 7, 2023 16 mins

Analytics R Language

Images considered harmful (sometimes)

Steampipe’s Mastodon dashboards are image-free for now, and I think it’s having a calming effect. Perhaps all social media interfaces should have an optional text mode.

By Jon Udell

Feb 3, 2023 4 mins

APIs SQL Web Development

Gradient descent in Java

Find out why backpropagation and gradient descent are key to prediction in machine learning, then get started with training a simple neural network using gradient descent and Java code.

By Matthew Tyson

Feb 2, 2023 15 mins

Artificial Intelligence Java Machine Learning

How to use implicit and explicit operators in C#

Take advantage of implicit and explicit operators to convert between user-defined types and improve the readability of your code.

By Joydip Kanjilal

Feb 1, 2023 5 mins

C# Libraries and Frameworks Microsoft .NET

Working with Mastodon lists

Steampipe makes it easy to create Mastodon dashboards, find interesting people, see which lists they’re on, and export lists in useful ways. Now we need ways to share and remix those lists.

By Jon Udell

Feb 1, 2023 4 mins

APIs SQL Web Development

Mastodon relationship graphs

Steampipe and SQL allow us to see relationships among the data we extract from APIs. Here’s how to graph the connections between tooters and boosters on Mastodon.

By Jon Udell

Jan 27, 2023 8 mins

APIs SQL Web Development

How to build a neural network in Java

The best way to understand neural networks is to build one for yourself. Let's get started with creating and training a neural network in Java.

By Matthew Tyson

Jan 26, 2023 9 mins

Java Machine Learning

Instance-qualified Mastodon URLs

Transforming foreign server URLs into home server URLs makes a Mastodon dashboard massively more useful. Steampipe’s Mastodon plugin now does that for you.

By Jon Udell

Jan 25, 2023 7 mins

APIs SQL Web Development

How to work with Action, Func, and Predicate delegates in C#

Learn how you can take advantage of delegates like Action, Func, and Predicate to facilitate callbacks and add flexibility to your code.

By Joydip Kanjilal

Jan 24, 2023 6 mins

C# Libraries and Frameworks Microsoft .NET

How to work with delegates in C#

Take advantage of delegates to promote flexibility and code reuse in your .NET applications and to implement event-driven programming with ease.

By Joydip Kanjilal

Jan 19, 2023 5 mins

C# Microsoft .NET Software Development

Styles of machine learning: Intro to neural networks

Modeled on the human brain, neural networks are one of the most common styles of machine learning. Get started with the basic design and concepts of artificial neural networks.

By Matthew Tyson

Jan 19, 2023 7 mins

Artificial Intelligence Machine Learning Software Development

How many people in my Mastodon feed also tweeted today?

You can discover which Mastodon tooters also tweeted using my favorite kind of Steampipe query.

By Jon Udell

Jan 18, 2023 3 mins

APIs SQL Web Development

Lists and people on Mastodon

When viewing the people you follow on Mastodon, it’s helpful to know which lists (if any) you’ve assigned them to. Here's how you can do that with SQL and Steampipe.

By Jon Udell

Jan 13, 2023 5 mins

APIs SQL Web Development

Using JavaScript and forms

Of all the hats JavaScript can wear, its form-processing features are among the most sought and used. Learn how to use JavaScript for form processing, validation, and more.

By Matthew Tyson

Jan 12, 2023 16 mins

JavaScript Software Development Web Development

How to use OpenAPI in ASP.NET Core

Take advantage of the built-in support for OpenAPI in ASP.NET Core to automatically document your HTTP endpoints. Minimal APIs are supported too.

By Joydip Kanjilal

Jan 12, 2023 7 mins

C# Microsoft .NET Web Development

Create your own Mastodon UX

A dashboard+feed reader built with SQL gives you an easy and natural way to consume as much, or as little, Mastodon activity as you like.

By Jon Udell

Jan 11, 2023 8 mins

APIs SQL Web Development

A Bloomberg terminal for Mastodon

Our brains are built to take in a lot of information at a glance, and if it’s organized well we can do that very effectively. Applying filters helps.

By Jon Udell

Jan 6, 2023 6 mins

APIs SQL Web Development

Intro to SvelteKit 1.0: The full stack framework for Svelte

SvelteKit 1.0 is here, and it is packed with features for full stack developers. Here's a quick tour of Svelte’s shiny new JavaScript framework.

By Matthew Tyson

Jan 5, 2023 9 mins

JavaScript Libraries and Frameworks Software Development

How to use the null object pattern in .NET

Take advantage of the null object pattern in .NET to eliminate the need for null checks and avoid runtime errors in your applications.

By Joydip Kanjilal

Jan 5, 2023 5 mins

C# Microsoft .NET Web Development

Browsing the fediverse

Steampipe’s SQLification of the Mastodon API is a handy way to track activity in the fediverse. Use it to do Mastodon analytics, find interesting people, and more.

By Jon Udell

Jan 4, 2023 3 mins

APIs SQL Web Development

Mastodon, Steampipe, and RSS

Using Steampipe to build a dashboard that combines queries of the Mastodon search API and the joys of RSS-powered integration.

By Jon Udell

Dec 29, 2022 6 mins

APIs SQL Web Development

How to create your own RSS reader with R

Sure, you could use one of the commercial or open-source RSS readers. But isn’t it more fun to code your own?

By Sharon Machlis

Dec 28, 2022 15 mins

JavaScript R Language Web Development

How to use symmetric and asymmetric encryption in C#

Learn how to protect the information handled by your .NET applications by encrypting and decrypting the data using either a single key or a public/private key pair.

By Joydip Kanjilal

Dec 22, 2022 7 mins

C# Microsoft .NET Software Development

Intro to the Observable design pattern

The Observable design pattern is found in many Java APIs and in reactive programming. Here's an introduction to the timeless Observable pattern in Java.

By Rafael del Nero

Dec 20, 2022 5 mins

Java Software Development

Error tracking with Sentry, Python, and Django

If you've ever wished for an easier way to track errors in Python-Django apps, Sentry could be the answer to your dreams. Let's get started with Sentry in Python.

By Matthew Tyson

Dec 15, 2022 8 mins

App Testing Python Software Development

How to work with endpoint filters in ASP.NET Core 7

Take advantage of endpoint filters in ASP.NET Core 7 to modify request and response objects, short-circuit the request processing pipeline, or handle cross-cutting concerns for every request.

By Joydip Kanjilal

Dec 15, 2022 6 mins

C# Microsoft .NET Web Development

Full-text search your own Mastodon posts with R

Some Twitter users migrating to Mastodon miss being able to run full-text searches of their own toots. Here's how to search your own posts using R and the rtoot package.

By Sharon Machlis

Dec 13, 2022 9 mins

R Language

How to use BufferedStream and MemoryStream in C#

Take advantage of the stream classes in .NET 7 for faster reads and writes of the data in your .NET applications.

By Joydip Kanjilal

Dec 8, 2022 6 mins

C# Microsoft .NET Web Development

Google’s Vertex AI Vision brings no-code to computer vision

Vertex AI Vision combines video sources, machine learning models, and data warehouses to deliver rich insights and computer vision analytics without the heavy lifting.

By Janakiram MSV

Dec 7, 2022 6 mins

Machine Learning No Code and Low Code Technology Industry

Intro to Mitosis: The universal reactive transformer

Mitosis is the JavaScript compiler that lets developers "write once, run anywhere," then compile to Angular, Vue, Svelte, and more. It could lead to a universal model of front-end development frameworks.

By Matthew Tyson

Dec 1, 2022 8 mins

JavaScript Libraries and Frameworks Software Development

How to use EF Core query types in ASP.NET Core 7

Take advantage of query types in EF Core to query types that don’t have keys and to map to tables and views that lack an identity column.

By Joydip Kanjilal

Dec 1, 2022 6 mins

C# Microsoft .NET Web Development

6 state management techniques for ASP.NET Core MVC

You have a number of different ways to store and retrieve data between requests in ASP.NET Core MVC applications. Here’s how to take advantage of them.

By Joydip Kanjilal

Nov 17, 2022 7 mins

C# Microsoft .NET Web Development

Filter JavaScript objects the easy way with Arquero

Use popular 'grammar of data' syntax to filter and subset your two-dimensional JavaScript arrays and more. Here's how to use Arquero for data wrangling in Observable JavaScript and Node.js.

By Sharon Machlis

Nov 16, 2022 8 mins

JavaScript

Intro to CSS-in-JS: Generating CSS from JavaScript

What is CSS in JavaScript and why is it suddenly popular? Learn how it works and get introduced to some of the leading CSS-in-JS frameworks.

By Matthew Tyson

Nov 10, 2022 8 mins

Development Tools JavaScript Web Development

How to work with logging in EF Core 7

Learn how you can use Entity Framework Core to log data to the console, SQL Server, and other log targets when working with ASP.NET Core 7 applications.

By Joydip Kanjilal

Nov 10, 2022 5 mins

C# Microsoft .NET Web Development

How to use the in, out, and ref keywords in .NET Core

Take advantage of the in, out, and ref keywords to pass parameters to your C# methods in .NET and make your code more readable and maintainable.

By Joydip Kanjilal

Nov 3, 2022 6 mins

C# Libraries and Frameworks Microsoft .NET

Golang tutorial: Get started with the Go language

Go is a concise, simple, safe, and fast compiled language with outstanding concurrency features. Now, it has generics, too. Isn’t it time you gave Go a try?

By Martin Heller

Nov 2, 2022 14 mins

Golang Software Development

How to use BitArray in .NET 7

Take advantage of the BitArray class in .NET 7 to perform bitwise operations on your data for improved performance.

By Joydip Kanjilal

Oct 27, 2022 8 mins

C# Microsoft .NET Web Development

CI/CD buyer’s guide: How to choose a cloud CI/CD platform

Hosting CI/CD in the cloud can speed up interactions between development pipelines and source code repositories and make life easier for developers. There are a surprising number of options.

By Martin Heller

Oct 24, 2022 16 mins

Build Automation Devops Enterprise Buyer’s Guides

Lazy vs. eager instantiation in Java: Which is better?

Learn how to use lazy instantiation and eager instantiation in your Java programs. Which approach is better? It depends on the scenario.

By Rafael del Nero

Oct 18, 2022 8 mins

Java Software Development

Natural language processing with Apache OpenNLP

Get a quick and easy introduction to natural language processing using the free, open source Apache OpenNLP toolkit and pre-built models for language detection, sentence detection, tagging parts of speech, and more.

By Matthew Tyson

Oct 13, 2022 10 mins

Java Natural Language Processing Open Source

Use model validation in minimal APIs in ASP.NET Core 6

Take advantage of FluentValidation to validate your model classes when working with minimal APIs in ASP.NET Core 6.

By Joydip Kanjilal

Oct 13, 2022 6 mins

C# Microsoft .NET Web Development

A beginner’s guide to using Observable JavaScript, R, and Python with Quarto

Using Quarto with Observable JavaScript is a great solution for R and Python users who want to create more interactive and visually engaging reports.

By Sharon Machlis

Oct 6, 2022 8 mins

JavaScript Python R Language

Learn Observable JavaScript with Observable notebooks

Free, hosted Observable notebooks provide an interactive experience and lots of open-source Observable JS code you can reuse and learn from. Here's how to get started.

By Sharon Machlis

Oct 6, 2022 9 mins

JavaScript Python R Language

Data visualization with Observable JavaScript

Learn how to make the most of Observable JavaScript and the Observable Plot library, including a step-by-step guide to eight basic data visualization tasks in Plot.

By Sharon Machlis

Oct 6, 2022 15 mins

JavaScript Python R Language

How to use cancellation tokens in ASP.NET Core 7

Take advantage of cancellation tokens in ASP.NET Core to allow long running operations to be cancelled gracefully and keep applications responsive.

By Joydip Kanjilal

Oct 5, 2022 7 mins

C# Microsoft .NET Web Development

Hands-on with MongoDB queryable encryption and Node.js

MongoDB queryable encryption means never having to decrypt sensitive data inside the data store, all but eliminating the database as a target of attack. Here’s how to get started.

By Matthew Tyson

Oct 5, 2022 10 mins

Databases JavaScript Web Development

Buyer’s guide: How to choose a cloud machine learning platform

12 capabilities every cloud machine learning platform should provide to support the complete machine learning lifecycle—and which cloud machine learning platforms provide them.

By Martin Heller

Oct 3, 2022 16 mins

Data Science Machine Learning Predictive Analytics