How to automate incoming e-mails with a restdb.io database

by Knut Martin Tornes
 - 
|Integrations| Howto|

incoming-email-automation E-mail is an important and integrated part of many systems. restdb.io has had decent support for automating outbound e-mail for a while now (more details in the restdb.io docs).

One of the new features, inbound email, opens up new possibilities for automation involving e-mail. All databases now get their own e-mail address and incoming e-mails are now stored in a collection for further processing.

In this short article, we will show you how to enable the feature together with an example of how to set up a codehook (trigger function) when the e-mail is received. We will also demonstrate how to use the new console debug output to see what's going on inside the codehook.

Announcing Azure Cosmos DB support for restdb.io

by Jon Erik Solheim
 - 
|Howto| Features|

restdb love azure

As you might know, restdb.io has support for MongoDB compatible querying using a simple REST based interface. Developers love that complex database specific details are hidden and simplified in one coherent developer experience.

However, in many cases, there are good reasons for developers and data owners to have more control of and access to their own database instance.

This blog post shows how you can connect restdb.io to an Azure Cosmos DB instance.

How we created a developer friendly email campaign tool using serverless only

by Knut Martin Tornes
 - 
|Tutorials| Howto|

Serverless is more There are tons of email marketing tools on the market, the most well-known being perhaps MailChimp and Campaign Monitor. These tools have varying prices and flexibility and each one has its own fanbase and target group.

We wanted to create a simple, developer friendly email campaign tool that we could use internally for our monthly newsletter at restdb.io (it's available as a database template you can play around with).

The requirements were these:

  • Edit the emails in Markdown syntax (to save time)
  • Possibility to upload email addresses using CSV/Excel or using an API
  • Ignore duplicate emails when uploading
  • Have an unsubscribe feature
  • Track emails sent and opens in realtime

And last, but not least: Everything should be written using serverless Javascript, HTML and NoSQL.

Difficult? Yes. Doable? Certainly! Read on.

Announcing MongoDB Atlas support for restdb.io

by Jon Erik Solheim
 - 
|User| Howto|

love-Mongodb In case you didn't know it, restdb.io is designed for use with the leading NoSQL database engine MongoDB.

restdb.io does not expose any of the details from the underlying database, hence the simplicity and speed of development that many developers love.

However, in many cases, there are good reasons for developers and data owners to control their own MongoDB instance.

We are therefore proud to announce support for external MongoDB databases.

This blog post shows how you can connect restdb.io to a MongoDB Atlas Cluster.

Host your project docs in a dynamic web database

by Knut Martin Tornes
 - 
|Howto| Tutorials|

Dynamic documentation template database

In your career as developer you've probably at some time felt guilty when the project manager asked you where the documentation is. "It's a self-documenting system", you say, trying to be smart.

What if there was a fun and simple way to write and share those docs? For all your (development) projects?

In this blogpost we'll show you how the DocHUB database template was created. It provides an easy way to create dynamic project documentation with Markdown using a restdb.io database as the content engine and the amazing Flatdoc for displaying and navigating the docs with a little Javascript magic.

The template has been very popular and has been installed many times by our users. If you're not into coding, you can of course just install it and use it as is. Otherwise, read on (and learn).

Send mail from your application

by Jon Erik Solheim
 - 
|Howto| Features| API|

mail Yes, your restdb.io database can now send email.

A simple REST endpoint on your database makes sending email from your application a breeze. A nice responsive HTML email template makes your application emails look great, even on mobile devices.

Chop your logs with capped collections

by Jon Erik Solheim
 - 
|User| Howto| Tutorials|

log Your database size is out of control, and collections are growing crazy fast.

You desperately need some automagical way to limit collection sizes to contain only relevant data, and chop off garbage data.

Relax, this is exactly what you can accomplish with a background JavaScript that caps collection data to a specific limit.

This blog post will show you how.

Next on your TODO: Go React native with restdb.io and Auth0

by Jørgen Tvedt
 - 
|Howto| Integrations| Tutorials|


Native apps for IOS and Android provide developers with options, performance and styling beyond the capabilities of the browsers. Up until recently, however, this meant learning and dealing with bespoke programming languages and SDKs. Fortunately, react-native have come to the rescue, offering a familiar JavaScript programming and standardized components for the major platforms.

Building a fully functional react-native app with persistence and authentication is surprisingly easy. Using restdb.io for cloud hosted data and Auth0 for user authentication, you get lots of features right out of the box. Follow the steps in this post and you’ll be up and running in no time.

You shall not pass - without a JSON Web Token

by Jon Erik Solheim
 - 
|User| Howto| API|


Accessing cloud data sources from JavaScript using AJAX and JSON is at the core of so many applications. There are several complicated approaches and there is JSON Web Tokens.

Thousands of developers have chosen to run their Authentication and Backends from cloud providers for one reason. Simplicity.

Enter JSON Web Tokens, Auth0 and restdb.io. Auth0 lets you set up a world class authentication system in front of your application - in 10 minutes. By using the JSON Web Tokens and the JavaScript API from restdb.io, your data API is easily protected.

After all, your application needs 100% of your attention on the core features, which is everything that happens between authentication and the data store.

You'll find a link to a working application example at the end of this article.

DevOps nirvana: Roll your own low-cost realtime server monitoring with Bash, Javascript and NoSQL

by Jon Erik Solheim
 - 
|Howto| Tutorials| API|

There are plenty of excellent tools to monitor servers in real-time (New Relic, LogicMonitor). These products have tons of features and often costs more than you are (eagerly) willing to pay. Maybe you just need something simple or something custom that you want to keep an eye on in a dashboard. Perhaps the Dev in you is bigger than the Ops? In any of those cases, this article is for you.

We will show how you can use a pre-made restdb.io database template to create your own DevOps server monitoring dashboard with JavaScript, Google Charts and Bash shell scripts. The setup is simple and will only take you a few minutes to try out.

Instant cloud apps with Snapp templates

by Knut Martin Tornes
 - 
|User| Howto| Features|


We have previously written blog posts with source code and plenty of examples of how to set up backends, web sites and blogs using a restdb.io database (see restdb.site).  

However, even though we provided detailed steps on how to set everything up, we felt the barriers was still there for developers to get going. We needed a way to share our examples without requiring people to set everything up themselves, a kind of snapshot or clone of a complete solution.

Meet our latest feature:  Snapps

Create a technical blog with Markdown and restdb.io in 39 lines of code

by Knut Martin Tornes
 - 
|Howto| Features| Tutorials|


We've just added two-way support for using Markdown. Any text field in a restdb.io database record can now easily be edited using the integrated Markdown editor and the built-in webserver of every restdb.io database can render the text as perfect HTML using the #markdown helper tag.

In this blog post we describe how we set up a restdb.io database to power a simple blog site using just a tiny amount of code.
 

A picture is worth a 1000 lines of code

by Jon Erik Solheim
 - 
|Howto| API|

restdb.io comes with a helpful media archive for documents and images. The media archive also has an API with full CORS support. This is really handy for providing your web application with dynamic content.

In this blog post we'll look at the media archive API and go through a JavaScript code example for a simple (ugly) web page showing the basics of the API.

Simple user authentication for web apps

by Jon Erik Solheim
 - 
|Howto| Integrations| Authentication|

User authentication is an important ingredient in application development. It both protects important data (i.e. APIs) and enables development of a personalised user experience.

It can, however, be a complicated and time-consuming process if you want to roll your own and it often requires a skilled backend developer to do it right.

This blog post shows how you can use Auth0.com and a restdb.io database to develop an application where users can sign up with your app and get access to their own data.

Please share this article with your developer friends :-)

Password protected Pages

by Jon Erik Solheim
 - 
|User| Howto|

Restdb Pages lets you create any content from your database and deliver it on a custom route. However, sensitive content must be protected. That's why we made it simple to include user authentication in any Page. All you have to do is to add the #auth tag to the Page source code.


The #auth tag instructs the server to require an authenticated user before serving the Page content. The example below shows how to protect a page with a simple username and password.

{{#auth}}
{"password": "secret", "user": "jane"}
{{/auth}}

My sensitive content here ...

How to create a dynamic site with HTML and CSS only (almost)

by Knut Martin Tornes
 - 
|User| Howto|

Do you dream of a simpler world where you could create a website with HTML and CSS only? The kind of site that web designers and SEO-experts love?

With the addition of Pages to restdb.io, it is now entirely possible and easy to create complete dynamic web sites with only HTML and CSS (almost). 

How to create an RSS feed with restdb.io

by Knut Martin Tornes
 - 
|User| Howto|


RSS (Rich Site Summary) is a widely used standard format to deliver regularly changing web content. Many sites and blogs syndicate their content as RSS feeds. People subscribing to feeds saves time, stays informed and enjoys greater privacy (no ads, no cookies).

In this blog post we show you how we created the RSS feed for our own blog (yep, this blog), using a restdb.io database and just a few lines of code in a restdb.io Page.

Introducing realtime REST events

by Jon Erik Solheim
 - 
|Features| Howto|


A brand new feature of restdb.io is support for really simple realtime messaging. 

Now, with only a few lines of code, you can update web pages dynamically whenever some data are created, updated or deleted in your database (POST,PUT,DELETE). We have also added custom events, so you can for example publish "GOAL" events or whatever.

Web Form Generator now support file and image uploads

by Knut Martin Tornes
 - 
|User| Howto| Features|


Great news! We have now released a new version of the Web Form Generator that will generate HTML and Javascript code for uploading files and images into your restdb.io database collections.

Simple real-time chat with streamdata.io and restdb.io

by Knut Martin Tornes
 - 
|Howto| Integrations| API|

restdb.io makes it simple to create a user-friendly, manageable database with a REST-API. For some types of applications, however, you need real-time updates delivered to your front-end web page or mobile app. 

Polling the API from the client could be an option, but often induces too much traffic. Services like Firebase has real-time data, but then you don't get the powerful data manager or the possibility to host web pages in your database like you can in restdb.io. This is where streamdata.io can add to the power of restdb.io. Streamdata.io let's you take any API and create a real-time data source for it!

Real-time is useful for many scenarios like chat, live financial data, games and live maps to mention a few. In this blog post we will show you how easy it is to use streamdata.io with restdb.io by creating a real-time chat running in a restdb.io HTML Page. 

Automated email response with restdb.io web forms and webhooks using Zapier

by Knut Martin Tornes
 - 
|Howto| Integrations|


With restdb.io's Web Form Generator, you can quickly generate a web form you can use to collect input from users on your site directly into a restdb.io database collection. Great!

However, it would be nice to be able to respond the users by email that the "application" or whatever information they submitted has been received. 

This blog post details all the steps necessary to do just that using restdb.io Webhooks with a Zapier Webhooks-to-Gmail Zap.

NoSQL aggregations made simpler

by Jon Erik Solheim
 - 
|Howto| API|


An aggregation processes data records and return computed results. With aggregation, you can group values from multiple documents together, and then perform a variety of operations on the grouped data to return a single result. It's perfect for creating reports or gaining more insight from your data.

If you've used MongoDB aggregations, you probably think this is difficult right? 

We'll show you how simple it can be with restdb.io.

How to create a Dashboard with RestDB

by Jon Erik Solheim
 - 
|User| Howto|

A Dashboard is a helpful tool for keeping people in the loop and quickly communicate important information.
This blog post will show you how to create a Dashboard with RestDB.
Our example is a database with Job applications from a web site.

Let (the) Postman deliver your REST-API code

by Knut Martin Tornes
 - 
|User| Howto| API|


At restdb.io we have created code examples for various platforms. It's often quite time consuming to find the right library and approach, especially if the programming language is new to you.

But did you know there exists a powerful tool which lets you generate client code for calling REST APIs for many popular languages? Meet (the) Postman.

Using Highcharts with RestDB

by Jon Erik Solheim
 - 
|User| Howto|


This simple example shows how you can use Highcharts to visualize data from a RestDB datasource.

In this example we'll create a database for a simple Time management application. 
Our database contains the following Collections: Customers, Projects and Hours.

If you got the numbers, RestDB will do the math

by Knut Martin Tornes
 - 
|User| Howto|

From spreadsheets you might be familiar with formulas and calculations. RestDB supports calculations (for example adding a field that includes price + VAT) and aggregation functions like sum, average, minimum, maximum and count. It's quite easy to set up.

Database Driven Web sites and Pages

by Jon Erik Solheim
 - 
|User| Howto|

Pages let you create dynamic HTML (and other) content inside restdb.io. This is a great way to develop unique user experiences driven by data from your database.

This blog post shows you how to get started. We will create a simple web page and publish it to the world.

Prototyping with Framer Studio and random data from restdb.io

by Jon Erik Solheim
 - 
|Howto| Prototyping| API|

In this blogpost we'll demonstrate how you can use restdb.io as a Data Generator for your Framerjs prototype.

I am no expert in how to create prototypes in Framer Studio, and the example is probably amateurish. However, my main goal is to show you how easy it is to connect and work with restdb.io and Framer Studio, almost in real time.

Generating good test data

by Jon Erik Solheim
 - 
|Howto|

Testing is a big thing in the prototype and development cycle. Creating and maintaining good test-data sets can be a cumbersome process. RestDB has an integrated Random Data generator that makes test-data a snap, and a natural part of your development toolbox.

Visualising IoT data with restdb.io pages

by Jon Erik Solheim
 - 
|Howto| API|

We are pleased to share some insights from a project that uses restdb.io as a backend to measure Air quality.

This blogpost shows how you can connect a BeagleBone Black device to restdb.io and how you can visualise the temperature curve on a page served directly from restdb.io. The BeagleBone is a low-cost, community-supported development platform for developers and hobbyists

Parent/child relations made simple

by Knut Martin Tornes
 - 
|Howto| API|

A parent/child-relation is a convenient way of organizing and viewing information in a one-to-many relationship. If you think about it, we use it all the time: 

  • Folders and files on your computer
  • Comments on a blog post
  • Activities on a project
  • Interactions with a customer
Creating this form of relation is very simple in restdb.io. In this blog post we will show you how to add some "Notes" to a "Lead" in a simple CRM system.