Node + MySQL + JSON

100%

Node + MySQL + JSON

✓ Published0🌍 Public

Last edited Dec 12, 2011

Created on Dec 12, 2011

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.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 05471e1965de232f4434a8624c8949dc

This example demonstrates a minimal Express.js server that serves player data from a SQLite database, exposing endpoints for retrieving all players or looking up a single player by email. The backend uses `express`, `body-parser`, and the `sqlite3` library, with an async utility function (`getPlayers` or `getPlayerByEmail`) handling database queries. Although no charting or visualization library is present, the code illustrates a typical API structure for feeding data to a front-end visualization. The root route returns a plain JSON message, while `/players` and `/playerByEmail` respond with JSON arrays or objects, showing how raw data would be delivered for subsequent graphical rendering.

WWill Carter

64% match

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

63% match

Loading thumbnail…

Gist 3999923c627bd9069b071df1ecf6864f

This example demonstrates how to configure a MySQL database connection using the Knex.js query builder. The code explicitly defines a client as `mysql` and passes connection parameters such as `host`, `user`, `password`, and `database` from environment variables (`process.env.jimDBHost`, etc.). It illustrates the typical setup pattern for connecting Knex to a MySQL server, preparing the connection object for subsequent queries. The visualization highlights the structure of the `require('knex')({...})` initialization call, focusing on the configuration object that specifies both the client type and the secure credential handling through environment variables.

JJWTappert

62% match

Loading thumbnail…

NodeJS

An interactive data grid demonstrates server-side rendering with AG Grid's Server-Side Row Model, fetching data from a MySQL database via a Node.js backend. The React-based interface supports grouping, filtering, sorting, and aggregation with custom column definitions that dynamically generate date, dimension, and measure fields. Features include saved group state using localStorage, custom styling with icons, and a side panel for column configuration. The implementation uses AG Grid React components, moment.js for date formatting, and custom value formatters for currency and percentages.

Mmfakboo

62% match

Loading thumbnail…

Directly render and serve d3 visualizations from a nodejs server.

This example demonstrates how to render D3 visualizations directly from a Node.js server, showing a line chart of normally distributed sample data. The server uses Node’s HTTP module and the D3.js library to generate SVG markup programmatically, then sends it to the browser as an `image/svg+xml` response. It constructs linear scales (`d3.scale.linear`), axes (`d3.svg.axis`), and a basis-interpolated line (`d3.svg.line`) entirely on the server side. The visualization is styled with simple SVG attributes, and the data is randomly generated via `d3.random.normal`, highlighting a server-side rendering approach where all D3 computations and SVG generation occur in Node before transmission.

CCaged

60% match

Loading thumbnail…

Gist 43d00ddea701789295809c54be1f7183

This example shows a live-updating fluid monitoring dashboard, displaying recent sensor readings for multiple tanks. The visualization uses a JavaScript backend with Knex.js to insert incoming data into a database, and a frontend that likely renders real-time charts or gauges for parameters like dissolved oxygen (DO) from the specified location. The code demonstrates the API endpoint where a POST request with a reading value is parsed and stored, triggering an update to the visual display. It uses the Express framework alongside Knex.js for database operations, while the frontend appears to employ SVG-based graphics for the interactive data representation. The demo focuses on the integration between data ingestion and dynamic visual feedback.

JJWTappert

60% match

Loading thumbnail…

Gist ca8ce8dbd8dbba7b501860f3d569f019

This example demonstrates a lightweight Express server that acts as a CORS proxy for a joke API, enabling browser-based requests to bypass cross-origin restrictions. The code uses the `express` and `request` libraries to define a route, `/jokes/random`, which forwards requests to `https://joke-api-strict-cors.appspot.com/jokes/random` and relays the JSON response back to the client. A middleware sets the `Access-Control-Allow-Origin` header to `*`, allowing any frontend to access the proxied data. The server listens on a configurable port, defaulting to 3000, and handles errors by returning a JSON error object. This setup illustrates a simple server-side solution for enabling client-side data fetching from a restricted external source.

115Dkatz

58% match

Loading thumbnail…

Cube Metrics Client (Node.js + WebSockets)

This example demonstrates a minimal Node.js client for streaming time-series metric data from a Cube server over WebSockets. It connects to the `/1.0/metric/get` endpoint, sends a JSON query requesting the sum of requests at five-minute intervals over a two-day period, and logs each incoming UTF-8 message until 762 responses arrive. The code uses the `websocket` library to manage the connection, sending a structured query and closing the socket after the expected number of messages is received.

Mmbostock

57% match