Audience
Data scientists in search of a tool to integrate narrative text with live code and visualizations
About SQLNotebook
SQL Notebooks allow developers to write Markdown combined with SQL to produce live HTML5 reports. They offer a lightning-fast, modern HTML5 interface where data sources are queried in real time. Users can create beautiful, live-updating SQL notebooks, easily source control the code, and take static snapshots to share with colleagues who don't have database access. SQL Notebooks are available in both QStudio Version 4, a desktop SQL client based on editing markdown files locally, and Pulse Version 3, which serves as a shared team server accessible via a web address. To help users get started, a showcase of example notebooks has been created in collaboration with leading community members; these examples are snapshotted versions with static data, and the source markdown and most of the data to recreate them are available on GitHub.
Other Popular Alternatives & Related Software
JackDB
Write and execute queries in a fully interactive SQL editor. JackDB has everything you'd want in a database client, including: syntax highlighting, code formatting, and intelligent autocompletion. Snippets allow your most useful SQL queries to be saved and shared. Simply write and save any query in JackDB, and share the snippet publicly with your team. Whenever anyone updates a snippet, everyone gets access to its latest version. Security is our highest priority at JackDB. Roles are a very convenient and secure way to restrict database access to authorized users and provision new users with access to data sources. Explore everything in your database, not just tables and views. View your indexes, schemas, and other important system details such as tablespaces and user sessions.
Learn more
R Markdown
R Markdown documents are fully reproducible. Use a productive notebook interface to weave together narrative text and code to produce elegantly formatted output. Use multiple languages including R, Python, and SQL. R Markdown supports dozens of static and dynamic output formats including HTML, PDF, MS Word, Beamer, HTML5 slides, Tufte-style handouts, books, dashboards, shiny applications, scientific articles, websites, and more. R Markdown provides an authoring framework for data science. You can use a single R Markdown file to both. When you open the file in the RStudio IDE, it becomes a notebook interface for R. You can run each code chunk by clicking the icon. RStudio executes the code and display the results inline with your file.
Learn more
Joplin
Joplin is a free, open source note taking and to-do application, which can handle a large number of notes organized into notebooks. The notes are searchable, can be copied, tagged and modified either from the applications directly or from your own text editor. The notes are in Markdown format. Notes exported from Evernote via .enex files can be imported into Joplin, including the formatted content (which is converted to Markdown), resources (images, attachments, etc.) and complete metadata (geolocation, updated time, created time, etc.). Plain Markdown files can also be imported. The notes can be synchronized with various cloud services including Nextcloud, Dropbox, OneDrive, WebDAV or the file system (for example with a network directory). When synchronising the notes, notebooks, tags and other metadata are saved to plain text files which can be easily inspected, backed up and moved around. The application is available for Windows, Linux, macOS, Android and iOS.
Learn more
Quiver
Quiver is a notebook built for programmers. It lets you easily mix text, code, Markdown and LaTeX within one note, edit code with an awesome code editor, live preview Markdown and LaTeX, and find any note instantly via the full-text search. A note in Quiver is comprised of cells, snippets of text, code, Markdown, LaTeX (via MathJax) or diagrams (sequence diagram, flowchart). You can freely mix different cell types within one note. You can set different languages for different code cells, too. The programmer's notebook should make code editing effortless. Quiver packs the awesome ACE code editor in code cells, with syntax highlighting support for more than 120 languages, over 20 themes, automatic indent and outdent, and much more. Quiver lets you write in Markdown with inline formatting and custom CSS options. A live preview window renders Markdown as you type. Quiver uses MathJax to typeset mathematical equations written in LaTeX.
Learn more
Integrations
Company Information
TimeStored
United Kingdom
www.timestored.com/sqlnotebook/
Videos and Screen Captures
Other Useful Business Software
Application Monitoring That Won't Slow Your App Down
Full APM with errors, performance, logs, and uptime monitoring. 99.999% uptime SLA on the platform itself.
Product Details
Platforms Supported
Cloud
Training
Documentation
Live Online
Videos
Support
Online
