Carnets vs SQL Recipes Pro

Jupyter notebooks are a powerful tool used in education and research. You can write small snippets of Python code and observe the result on screen, combine with paragraphs of text, using Markdown. Carnets provides a complete, stand-alone, implementation of Jupyter notebooks. Everything runs on your device, using the embedded Python interpreter; you do not need an internet connection. You can chose between Jupyter notebooks and the more advance Jupyterlab using Settings. Numpy, Sympy, Matplotlib, Pandas, lxml, bokeh, nbextensions (including ipywidgets) and many other packages are pre-installed. To see the full list of installed packages, type "%pip list" in a code window. You can add more packages using "%pip install packageName", but only if they are pure Python. If you need scipy, seaborn or scikit-learn, please use our other App, "Carnets - Jupyter (with scipy)". You can share your notebooks with other apps and also open notebooks or directories managed by other apps. Partial list of installed packages: astropy, babel, bokeh, cryptography, cvxopt, Fiona, geopandas, geopy, lxml, matplotlib, numpy, openCV, pandas, pillow, pyFFTW, pyproj, rasterio, regex, shapely, sympy, wordcloud.

An everyday SQL reference, from your first SELECT to window functions. Every query comes with an explanation, and most of them run. • 39 sections: filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views. • Run in the app: more than half of the queries execute against a live practice database, and the result table appears below the query. Needs an internet connection; the practice database allows 80 runs a day. • Changes in new versions: 7 sections from SQL-92 to SQL:2023, showing what each standard added, with the old and the new query side by side. • Dialects compared: MySQL, PostgreSQL, SQLite, MS SQL Server, Oracle, Firebird, Access. Where they differ, each one is shown separately. • The practice database is the classic MySQL world sample database: countries, cities, languages. The tables are described in the app. • Edit any query and run it again; one tap brings the original back. • Add your own queries; they stay in the app and are always at hand. • Search by section name or by a fragment of a query. • Everything except running works offline: queries, search, favorites. • Light and dark themes, font and size, line numbers, soft wrapping. Every query example is drawn from trusted sources and thoroughly tested. Built by a developer for developers. In active development since 2015.