Changing Columns in SQLite Tables
A recent purchaser of SQLVue, our SQLite IDE for database developers, requested for a new feature: the ability to modify existing columns on a table. Currently SQLVue does not support this and until it does, I thought I would explain how you can do this manually. But first, why does SQLVue not support this obviously useful feature? Well, the reason SQLVue does not support this yet is because...
Read MoreSQLVue 4.1 Now Available
SQLVue 4.1 is now available in the Mac App Store and is on sale for $14.99 through June 14th: App Store Link New features include: New features for SQLVue 4.1 include: * All-new table designer: create and alter tables without using SQL * Easily create Views from SQL statements * Export database table structure as SQL commands to include in your apps * Ensure the quality of your SQLite databases...
Read MoreSQLvue in the Mac App Store
Imagine my happy surprise when I opened the Mac App Store this morning to see that SQLVue is now the #2 “Top Paid” app in the Developer Tools category (behind only Xcode). Even better, it’s #3 in the “Top Grossing” list! This is very exciting! And as of right now, SQLVue is #93 in the “Top Paid” list of all apps in the Mac App Store (it’s #87 in...
Read MoreAnnouncing SQLVue 4.0
SQLVue 4.0 is now available. SQLVue is a new, elegant IDE for SQLite developers. You can purchase it through the Mac App Store at a special introductory price of $9.99 through April 15th.
Read MoreSQLite Naming Standards
Everyone who writes code has their own naming standard, but it’s also important to have database naming standards. Here is what I use when working with SQLite. Tables First, all my tables are named in singular using mixed case. So a table containing all the teams in my kids Little League would be called Team. Whether you specify it or not, SQLite assigns a rowid column to every table you...
Read More