Lora Sniffer vs SQL Client

The LoRaSniffer App is the user-interface for the LoRaSniffer Device. The combination of both, the device and the app, is a tool for technicians and hobbyist allowing to use LoRa radio communications for testing and network maintenance. The LoRaSniffer Device is a LoRa radio module that can use all possible features the LoRa standard offers. This app is its convenient user-interface. It connects via BLE to the device to allow access to all its setup-parameters, receive communications from other LoRa nodes and send data via LoRa. Using 2 coupled LoRaSniffer devices, it can provide valuable information about network quality in a real-world scenario. The app provides a logging window with features for: formatting of received communications, additional time-stamp and the GPS location where each message was received. Each received message is tagged with "Quality of Signal" information as CRC, SNR, RSSI and carrier-frequency offset. The app allows as well to save the logged data as a visual document in HTML or as JSON protocol file. Messages can be sent as ASCII-text or as binary data. Tools allow to scan for channel activity, calculate transmission times for specific payloads or, if used with 2 devices, allow to gain real-time information to optimize LoRa networks in the field. More, the app can be used as well to update the firmware of the LoRaSniffer device.

SQL Database Manager is a SQL editor and database client for mobile phones. Connect to PostgreSQL, MySQL and SQLite databases, run SQL queries, and explore your data from your phone or tablet. Add Redis, MongoDB, MariaDB, CockroachDB and ClickHouse when you need them, and reach private servers through a secure SSH tunnel. Whether you need a quick psql-style client for Postgres, a MySQL client on the go, or a SQLite editor to practice SQL, SQL CodePad puts a full database tool in your pocket. SQL EDITOR BUILT FOR MOBILE • SQL syntax highlighting and smart SQL code completion that knows your tables and columns • The statement under your cursor is outlined, so you run one SQL query, not the whole script • Run many SQL statements at once, or one at a time • Code snippets and your own custom snippets • Editor themes, fonts and font sizes, free for everyone DATABASE CLIENT FOR POSTGRES, MYSQL AND SQLITE • Connect to PostgreSQL (Postgres), MySQL and SQLite databases for free • Browse database tables and columns in a schema tree, and tap a name to put it in your query • Run SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER and DROP to manage tables, views, indexes and triggers • Save as many database connections as you need, and paste a connection string to add one fast • Built-in sample databases, including Chinook SQLite that works offline SSH TUNNEL FOR SECURE DATABASE ACCESS • Connect to a Postgres, MySQL or other database server through an SSH tunnel with a private key or password • Host key verification, so you know which server you are talking to • SSH and database passwords are stored encrypted on your device and never leave it, except to sign in to your own server MORE DATABASES: REDIS AND MORE • Redis client: run Redis commands, with command completion and results in a table • MongoDB, MariaDB, CockroachDB and ClickHouse support • One app for SQL and NoSQL databases EXPLORE YOUR RESULTS • Results in a fast grid with sorting and filtering • Copy rows, or export to CSV, JSON, Excel, TSV, Markdown and SQL INSERT • See the number of rows and how long each query took AI ASSISTANT • Explain a SQL statement step by step • Fix a SQL error with one tap • Describe what you want and get the SQL query written for you LEARN AND PRACTICE SQL SQL CodePad is also a place to learn SQL. Practice queries on the built-in SQLite database, with no server to set up. It is a good fit for beginners, students, developers, data analysts and data scientists. FREE AND DEVELOPER UPGRADE Use SQL CodePad free with PostgreSQL, MySQL and SQLite. The Developer upgrade unlocks the AI assistant, Redis, MongoDB, MariaDB, CockroachDB and ClickHouse, SSH tunnels, data export, code completion extras, the coding keyboard and an ad-free experience. Start with a free trial where available. Cancel anytime. Download SQL CodePad today: the SQL editor, Postgres and MySQL client, SQLite tool, SSH tunnel and Redis client in one database app. Terms of use (EULA): https://cloudbit.hr/eula/cloud_mobile_apps/