SQLite Professional for OS X is now pay what you want

https://www.sqlitepro.com/

by zenox • 12 years ago

23 15 12 years ago

zenox2• 12 years ago

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.

mwcampbell• 12 years ago

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.

Argorak2• 12 years ago

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.

petilon• 12 years ago

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.

Argorak2• 12 years ago

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

kolev• 12 years ago

I'm sure they mimic SequelPro for SQLite.

jws• 12 years ago

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.

SQLite2• 12 years ago

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.

SQLite2• 12 years ago

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.

joshstrange2• 12 years ago

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/

zenox2• 12 years ago

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.

joshstrange2• 12 years ago

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

foxwoods• 12 years ago

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...

SQLite Professional for OS X is now pay what you want

Related Stories