SQLite Professional for OS X is now pay what you want | Hacker News Reader

SQLite Professional for OS X is now pay what you want

sqlitepro.com

23 pointszenox15 comments

I wonder if naming a product "SQLite Professional", when the company has no affiliation with the SQLite Consortium or HWACI (the company that originally developed SQLite and does sell commercial extensions), is a trademark violation. If I hadn't gone and checked the copyright notice at the bottom of the web page, I would have assumed that this was a product of HWACI.

Considering that SQLite is licensed public domain with the express permission of others selling modifications of it without restrictions (even without acknowledging the original authors), I'd be surprised they mind.

For the sake of the user base, I hope they do mind. It is confusing to have SQLite and SQLite Pro when they are not from the same people.

Not really, SQLite Pro is not a database, but a management tool. Pretty hard to confuse the two unless you're someone who's not likely to use either.

The naming I assume comes from Sequel Pro. It sounds a lot better than SQLite database management tool 2.0

Could you please explain the (multiple) downvotes? Anything factually incorrect? Any obviously wrong conclusions?

For those wondering, I quote the copyright release document:

> Because the SQLite software found at http://www.sqlite.org/ is in the public domain, anyone is free to download the SQLite software from that website, make changes to the software, use, distribute, or sell the modified software, under either the original name or under some new name, without any need to obtain permission, pay royalties, acknowledge the original source of the software, or in any other way compensate, identify, or notify the original authors.

http://www.sqlite.org/copyright-release.html

I'm sure they mimic SequelPro for SQLite.

Here we leave the realm of copyright and enter trademark law. HWACI's operating instructions reference their trademark on SQLite. Given that the reasonably adept HN readership has members confused into believing this was an HWACI product it seems to fall squarely in the realm of trademark violation.

It is a violation of the SQLite trademark, I believe. I have sent a gentle email to the "sqlitepro.com" company pointing this out to them and suggesting some simply changes that will avoid the trademark violation. Hopefully they will take prompt action to clear up the confusion caused by their website and product and we can move on from this without further complications.

I received a gracious reply from the Hankinsoft developers. They have already added a disclaimer to the website and are promising to make the distinction between their product and SQLite even clearer over the next few days. Hopefully any confusion will be cleared up soon.

4.5 star rated sqlite development tool. The pay what you want feature is only available via the web store, as apple does not offer any such service.

How does this compare to Base[0]? I bought and have been using Base for years and it's been awesome. Granted I don't do much sqlite work so Base may be a little "simple" but I don't see much in SQLite Pro that rivals what it offers.

[0] http://menial.co.uk/base/

A few things that SQLite Professional does that Base does not.

1. Get results for multiple queries at once. A simple example would be SELECT 'hello'; select 'world'; which will return two result sets, where base will only return the first one.

2. If your select query contains a tables primary keys, then the results from a query can be edited inline. Example if you run SELECT * FROM myTable WHERE id IN (1,2,3) then you can actually edit the results directly without needing to switch back to the data view.

3. If you have a trigger or view that depends on a specific column or table, and the column/table gets renamed, SQLite Professional will prompt you with the details and alter the underlying trigger/views to be updated with the new proper information.

4. SQLite Professional will automatically reload if your database is modified by an external app (such a directly via a sqlite3 prompt, a php script, etc).

That said, Base is a great app. If you already own a copy of it and the above functionality does not interest you, I would probably just suggest keeping with it.

Thanks for the quick reply, I'll be sure to check it out!

If you only need a management UI for SQLite, the Firefox addon SQLite Manager[0] is a good choice, and it's free.

[0] https://addons.mozilla.org/en-US/firefox/addon/sqlite-manage...

Reply on news.ycombinator.com