


It is used as a database app development tool, and as a database engine.ĭoes this service offer multi-user capability (e.g. Knowledge Base, Phone Support, Online Support, Downloads, Webinars, Video Training. TablePlus | Modern, Native Tool for Database Managementĭoes this service offer guides, tutorials and or customer support? Increased number of peer-to-peer file sharing users – Share files with up to nine concurrent users with FileMaker Pro Network Sharing. Save data in Adobe PDF and Microsoft Excel format.Īdd text notes to tables in the relationships graph.Ĭopy and import tables across files or within the same file. Import data from another file into a new table in the current file.

TablePlus supports most of the popular databases such as MySQL, Postgres, SQLite, Microsoft SQL Server, Redis, Redshift, MariaDB. It’s purpose-built for simplifying database management and reducing administrative costs. TablePlus is a modern, native Database Administration Tool with an elegant user interface that allows users to create, organize, access and share information in a fast and secure way. With all that features ready for use, individuals and organizations around the globe use the FileMaker Platform to manage contacts, inventory, and projects.

The program supports a decent number of file types for data import including Excel, tab- and comma-separated text, ODBC, DBF (dBASE) and more. It integrates a database engine with GUI interface enabling users to create and modify the database by dragging elements into layouts or forms. WHERE (entity_id = 'sensor.FileMaker is a very useful tool that lets its users create databases, available for both the PC and the Mac. If you are going to experiment, first shutdown HA for a bit and copy the SQLite database to a test copy and then explore this copy of the data without effecting your HA running instance : - get SCE whole house power Be gentle with your queries on the SQLite database of HA, if that is your default database, as it not as robust as other database. Query example to get whole house power usage for last two days, the SQL code may vary some for use with SQLite. I used Postgresql as my database for HA, however this tool will query the native SQLite database of HA as well. I have found the free version of TablePlus very useful to export csv data from my Home Assistant states and events tables.
