Async node-postgres sample code

100%

Async node-postgres sample code

✓ Published0🌍 Public

Last edited May 27, 2016

Created on May 27, 2016

This example demonstrates a web server that tracks and reports visitor counts using an asynchronous PostgreSQL workflow. It uses Express routes and the `node-postgres` library to insert a timestamp into a `visit` table and then query the total count, returning the result as an HTTP response. The code highlights both modern async/await syntax with `await query(...)` and a callback-style alternative using `errto` for error handling, showing two equivalent approaches for database interactions.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 444255

This example demonstrates a Node.js server that queries MongoDB collections and logs their contents to the console, primarily as a backend testing or debugging tool. The code uses the `mongo.Db` and `mongo.Server` APIs to connect to a local MongoDB instance on port 27017, then defines HTTP routes via a `get()` handler. For each route, it retrieves documents from specific collections—`some-collection` and `another-collection` (the latter with a limit of 10)—and prints each item using `sys.puts` and `sys.inspect`. The visualization aspect is absent; the example focuses on database interaction and response handling.

CCaged

61% match

Loading thumbnail…

Gist 8487030

This example shows a Node.js server endpoint that handles user creation through a series of asynchronous validation and persistence steps. The code demonstrates a Koa-style generator function using `yield` for control flow, with `parse` to read the request body and `password` to generate a salt and hash. It validates the user schema, checks for an existing username with `users.findOne`, and inserts the new user with `users.insert`, returning a 201 status. The example relies on promise-based database and password utilities without any visualization libraries.

Aalessioalex

61% match

Loading thumbnail…

Gist 1a03bf15beee9f72953b414669e44576

This example demonstrates a Node.js utility that asynchronously fetches the HTTP status code for a given URL. It first reads a text file using the `fs.readFile` method to extract a domain or URL from its first line, then passes that address to the `request` library’s `getStatusCodeAsync` function, which returns the server’s response code. The visualization shows how file I/O and network requests are chained through callbacks, highlighting the flow of data from local storage to remote servers without any graphical rendering.

MMailnickko

61% match

Loading thumbnail…

SQL builder sketches for node.js and node-postgres

Three variations of a JavaScript SQL query builder sketch generate `UPDATE` statements with parameterized placeholders for the node-postgres driver. The code demonstrates both a single-call function with positional arguments and a fluent, chainable interface named `UPDATE` that supports `.SET()`, `.WHERE()`, and `.RETURNING()` methods. Common utilities like `Object.keys`, `Array.map`, and `assert` manage column-value pairs, while the chained version tracks placeholder numbering against accumulated `values`. A third, prototype-free variant shows an alternative closure-based approach. The examples illustrate different API design patterns for safely composing dynamic SQL.

RRandomEtc

60% match

Loading thumbnail…

Gist 4ff85e89516594d9399c15b3c436878f

This example demonstrates JavaScript Promise patterns for asynchronous server communication, showing fetch(), .then(), .catch(), Promise.all/race, custom Promise construction, and async/await syntax. The code samples use the browser's built-in fetch() API against document.URL.toString() to simulate server checks, with console.log output for results and error handling. It also includes a setTimeout-based delay Promise example to illustrate timing control. The gist serves as educational reference material, contrasting Promise chains, custom Promise creation, and sugar-syntax async functions.

MMistyBlunch

59% match

Loading thumbnail…

ES7 multiple async/await functions in parallel execution.

This example demonstrates how to refactor a sequential async/await loop into parallel execution using JavaScript Promises. It shows three versions of the same Express route handler that fetch product reviews and then look up user details for each review. The code uses async/await syntax, `Promise.all`, and `Array.prototype.map` to concurrently query an `accountsQuery` data source for each review, returning a merged JSON response. The final solution attaches a `.catch` handler to each review promise, ensuring a single failed lookup does not reject the entire `Promise.all` batch.

Aackuser

59% match

Loading thumbnail…

Gist dfebda550a6847a46725afb2cfdb1253

This example shows an order-service application built with React, managing order data through a PostgreSQL database via Sequelize and Express. The code defines REST API endpoints for creating, retrieving, and updating orders, using JSON validation with Ajv and TypeBox schemas. It integrates RabbitMQ through amqplib for message queuing, JWT token verification for authentication, and includes comprehensive Jest testing with nock for HTTP mocking and Sinon for spies. The visualization demonstrates a server-side Node.js architecture with async/await patterns, error handling middleware, and logging.

TThomasG77

59% match

Loading thumbnail…

Node + MySQL + JSON

This example demonstrates a Node.js server that serves JSON data from a MySQL database to a front-end visualization. It sets the server’s timezone to UTC and uses Express to handle HTTP requests, with the `connect-gzip` middleware compressing responses. A GET endpoint for `/things/:id.json` queries a MySQL table named `things` via the `mysql` client, selecting fields like `name`, `favorite_color`, and `airspeed_velocity` based on the numeric ID from the URL, then returns the result as JSON. The code shows a direct pipeline from database query to API response, ready for consumption by a client-side chart.

Mmbostock

59% match