Likelihood to Recommend High-performance, high-concurrency transactions are well suited for ASE. ASE is lacking some features in my opinion such as history tables, however there are ways to implement them via workarounds or by using Replication Server. I do think the way the ASE parser and optimizer works are far superior to other products as it is a true cost-based optimizer and the order of the tables in the FROM clause does not really matter although a good SQL coder will place the tables in a meaningful order to make the SQL more readable. ASE is good for applications that require high availability and can be used for mission critical systems.
Gene Baker Vice President, Chief Architect, Development Manager and Software Engineer
Read full review It's a great tool when building the software, the ability to add SQL and No-SQL databases. Very convenient to write the queries and generate the filtered data we require. Gives the ability to export, import databases of various formats and generate reports from them. It might not be suitable if you want the data to be seen in a visualized manner
Read full review Pros Easy to setup and maintain Reliable, rarely has major hiccups requiring reboots or crashes Very responsive with complicated queries spanning various tablespaces and hundreds of millions of rows Read full review Table filters are simple and easy to use I love the ability to install plugins: Export tables to Laravel migrations is one of our most used plugins Super easy to connect to local Docker containers, Vagrant and remote DBs through SSH Read full review Cons Full database encryption - need to utilize external keys vs internal - for better separation of duties. History Tables. Gene Baker Vice President, Chief Architect, Development Manager and Software Engineer
Read full review It crashes CONSTANTLY. If you have more than one connection tab open and close one of them, it crashes. If you just have it open in the background, it randomly crashes. If you're using it, it randomly crashes. When you try to send a crash report, the CRASH REPORTER CRASHES. Can be a bit slow. No way that I'm aware of to query multiple databases in the same query. Read full review Likelihood to Renew Our licenses are perpetual. It is the support that we will be renewing. We will renew because we continue to use and receive value from the product.
Gene Baker Vice President, Chief Architect, Development Manager and Software Engineer
Read full review Usability It does almost everything we need and for the things it doesn't do natively, we are still able to do using other features. For example, natively history tables weren't supported but we were able to create them using triggers.
Gene Baker Vice President, Chief Architect, Development Manager and Software Engineer
Read full review Support Rating Incredibly responsive, saving us countless hours in troubleshooting.
Read full review It's open-source and very convenient to work with. I can easily import any database I want using a data dump and runt the queries on them to derive the data insights on the data. I might want to use Excel to visualize that, that might be one of the disadvantages.
Read full review Alternatives Considered Much less effort than Oracle. Much better customer support than Oracle. Roughly equivalent to SQL Server in performance and ease of use. Much better customer service than SQL Server. Different ballpark from IQ. Same customer service.
Read full review MySQL Workbench is a wonderful tool, but the routine editing of existing data is note nearly as straightforward as it is in Sequel Pro. The ability to sort a data view with a single click makes Sequel Pro my definite choice. phpMyAdmin is pretty ubiquitous, but the routine editing of existing data is much more cumbersome than it is in Sequel Pro.
Read full review Return on Investment Negative - Costs a lot ... but so do they all. Positive - It does what we need it to do. Read full review The user interface is great. Since all of our computers are macOS based, we can all use it and share knowledge with our colleagues It enables me to make things in such a faster way that it enables us to spend our time with coding and providing more solutions to our clients The workflow is much improved with the import and export feature, so we don't waste time with that kind of work. Read full review ScreenShots