SQLite

SQLvue in the Mac App Store

Posted by on Apr 5, 2011 in Database, REAL Studio, Software Business, SQLite | 4 comments

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 More

Announcing SQLVue 4.0

Posted by on Apr 4, 2011 in Database, SQLite | Comments Off

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 More

SQLite Naming Standards

Posted by on Apr 29, 2010 in Database, SQLite | Comments Off

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