10月6日的AnyData - Design your database应用程序分析

AnyData lets you design a custom database on your iPhone or iPad—no account and no cloud required. BUILD YOUR SCHEMA • Workspaces keep separate databases on the same device • Enumerables define reusable pick lists (unique values, deletable) • Classes define tables with typed properties: String, Date/Time, Date, Time, Integer, Float, Color, Enumerable, and Class references • All properties are optional ENTER DATA • Edit instances with constrained controls (pickers, number pads, date/time, color) • Forms provide a clean, class-bound entry UI—Submit saves and clears for the next record EXPLORE WITH VIEWS • Create views on one or more classes • Choose output columns (shown as Class › Field) • Optional filters (AND/OR) with typed comparators • Optional GROUP BY with Count, Sum, Average, Min, Max, and Median • Related classes join on Class references; unrelated classes use a Cartesian product • Sortable tables with Class drill-down into record details UNDERSTAND STRUCTURE • Interactive ER Diagram—drag tables, pinch to zoom, Auto Layout, export PNG or PDF • Generate Sample creates an Oracle HR–inspired demo schema, views, and forms EXPORT • Export ANSI SQL DDL (tables, primary/foreign keys, views) • Export data as INSERT statements • Export data as CSV (zipped per-table files) • Share via the system share sheet Privacy-friendly: data stays on your device using on-device storage. Light and Dark Mode supported.