Search Results for "json export"

...It also supports common editing actions, including inserting, updating, and deleting rows. Users can add or drop tables, columns, and indexes, and they can import or export data in JSON or CSV format. It can run from the command line, through Docker, or with a higher-performance gevent WSGI server, making it useful for quick database inspection, lightweight administration, and local development workflows.

ExcelToDatabase is an automated tool for batch-importing Excel data into a database. It supports 10 popular databases including MySQL, Oracle, SQL Server, PostgreSQL, and so on. Supported file formats include xls, xlsx, xlsm, xlsb, csv, txt, xml, json, and dbf. Its native user interface brings users a comfortable experience for simplified Excel import and export, making it easier than ever before. Whether you want one-click, batch, or personalized import/export, or use scheduled tasks for unattended full automation, ExcelToDatabase delivers unprecedented productivity improvements. ...

Records is a Python library designed to make direct SQL querying convenient without introducing a full object-relational mapper. It supports relational databases including PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, and Amazon Redshift through SQLAlchemy. Query results are exposed as friendly Record objects whose fields can be accessed by attribute, key, or numeric index. Queries support safe parameterization, SQL files, transactions, and bulk operations. Result collections can...

pyMantis is a data-management system for (systems) biology build on the web2py framework. It features: tree based file explorer, relational db table wizzard with automated creation of user interfaces, internal and external access management, wiki, ..