beDBlite

beDBlite for editing your SQLite databases. OPEN AND BROWSE DATABASES Open any SQLite database via the file picker – recently used databases are remembered. Tables and views are clearly marked and can be browsed in the sidebar. EDIT CELLS DIRECTLY Change the value in any cell directly, create new rows with hints for default values and required fields, NULL values are clearly displayed. FILTER, SORT AND LINK Filter any table with a WHERE condition and sort it with ORDER BY, page through rows, jump straight to a linked row in another table via foreign key navigation. FULL-TEXT SEARCH Search across all tables, with a match count for each result. SQL CONSOLE AND QUERY EDITOR Run free-form SQL and export results to a new file or append them to an existing one. Save query results directly as a new view in the database. SCHEMA TOOLS Create new tables, views, indexes and triggers via the SQL editor, duplicate, empty or delete existing tables – each with a confirmation prompt. EXPORT Export the schema, a single table, or the entire database as SQL. DIAGNOSTICS View database information, run an integrity check, and optimize the database (VACUUM). NO FRILLS • No user accounts, no ads, no tracking