Releases: open-source-labs/dbSpy
dbSpy v8.0
New and Enhanced Features in dbSpy 8.0:
Test New Query Page - a modern querying interface
- Run SQL queries against PostgreSQL or MySQL DBs
- Live results + metadata: execution time, query name, timestamp
- Zustand-powered state management
- Input validation and error handling
- Component-level Jest + React Testing Library tests
View Saved Queries Page
- Access previously saved queries per user
- Sortable, styled tables with TypeScript typing
- Track query performance across data models
UI / UX Enhancements
- TailwindCSS redesign: colors, layout, interactions
- Responsive and fully supported dark/light mode
- Logo animation integrated in navbar
- Sidebar and tab layout fixes
Functional Fixes
- Resolved layout shift bugs
- Optimized backend response handling
- OAuth (GitHub + local login)
New Contributors
dbSpy v5.0
Enhanced Features in dbSpy 5.0:
-
In the latest version, dbSpy 5.0, we’ve introduced several exciting features to enhance your experience:
-
Expanded SQL Database Support: Enjoy broader compatibility with popular SQL databases, including PostgreSQL, MySQL, Microsoft SQL, and OracleSQL with SQLite3 nearing completion, offering more options for your database needs.
-
Visualized Data Tables: Gain improved data analysis capabilities with visual representations of your data tables.
-
Full CRUD Functionality: Experience complete control over your database with the ability to add, modify, and delete columns in schema tables and rows in data tables.
-
Table Removal Capability: Easily remove tables as needed to maintain a clean and organized database structure.
-
Streamlined User Authentication: dbSpy 5.0 now implements Google and GitHub OAuth log-ins, providing a seamless and secure user authentication process.
v4.0.1
What's new?
On the surface
- Fixed foreign key bug on larger viewports
- Fixed issue where certain users were unable to sign up
- Improved performance of Postgres remote connection
Under the Hood
- Implemented several server and testing improvements
- Integrated with GitHub Actions for better continuous integration
v4.0
This version includes easy to use features such as undo/redo, query generation, and overall improved UI to enhance user workflow.
What's new?
On the surface
- Improved user sign up/login
- User database saving + reloading
- Dynamic handle placements on table relationships
- Added MySQL remote connections
- Streamlined table/column creation
- Undo/redo functionality
- Query generation + export
Under the Hood
- Improved testing coverage
- Increased reusability of SQL parser
- Refactored state management to better utilize Zustand hooks and stores
- Repaired page routing bugs
- Configured SSL for mySQL remote connections
res.sendFile(path.join(__dirname, '../../dist/index.html'));