SQL Server 2017 brings the power of SQL Server to Windows, Linux and Docker containers for the first time ever, enabling developers to build intelligent applications using the
As I am using this product from last 6 years I am very much happy with the features that SQL provides some of them are:-
1. SQL is best for managing data in the relational forms so that the data integration and consistency maintain properly.
2. As SQL supports most of the data types like (int, char, varchar, float etc..) which makes developer life easy to integrate with and application and language.
3. SOL also provides the bulk insertion and extraction of data and also supports the different data source like excel , notepad and all..
4. SSIS and SSRA are the best and ever green feature of the SQL. Review collected by and hosted on G2.com.
I do not have much complaints on dislike about the product .But just wanted to highlight one observation
Error handling mechanism can be much better so that the developer can get to know exact issue in SQL scripting.
Because most of the time SQL compiler not showing expected error message and no suggestion as well.
This is the only one I would like to highlight in dislike section. Review collected by and hosted on G2.com.
We are providing the database solution to the different application owner so that the application data become more secure and also can maintain and store for required period of time based on the requirement and application needs.
As its stored the data in the tables and relational form it is becoming very helpful and easy to generate reports based on the SQL commands in very less effort.
We can also easily extract the required data in any required format too and can share it with management to take the required decisio. Review collected by and hosted on G2.com.
The thing I like most about MySQL is, It is available for multiple operating systems like Windows, Linux, etc. It is free and open-source. It is very lighter in comparison to MsSQL and very fast. It is very easy to learn and use. It is very easy to install, configure and manage. The syntax is very identical to the same we use sentences in English. It is capable to hold large data in tables. It is best free database with enterprise level features. It is supported by almost all popular programming languages. There are numerous 3rd party custom tools available for it. Review collected by and hosted on G2.com.
With huge data, I had faced data loss and improper data retrieval but it is very rare and manageable. Some of the error messages are so general and unable represent the actual problem. Some error messages are so weird then the actual problem. It gives sense of insecurity at some points. Review collected by and hosted on G2.com.
MySQL is the best choice, If you need a powerful, fast and featured database for free. You will find it fulfilling your needs in any environment. It will not restrict you to use it on Windows. Numerous 3rd party tools are also available to enhance your experience with MySQL. It is very easy in syntax, setup, configuration and implementation. Review collected by and hosted on G2.com.
Our application has 2-way interface, data-entry and user / customer interfaces. On one hand it is being used with .Net for data-entry part of application and on other hand being used with PHP for user / customer interface. The .Net part is deployed locally while user / customer interface is deployed on Azure. A in-house developed desktop utility is also being used to transport data from local MySQL server to Azure MySQL database. We are having almost 2M+ transactions in few tables, working well. It helps us to save the licensing cost. It is also being used in our other websites in backend for data storage and retrieval. Review collected by and hosted on G2.com.
Ninox is the easy no-code platform for everyone. Create your own Business Application that matches your workflow. Additionally Ninox promotes team collaboration functionalitie
The flexibility of the software allowed me to start with a simple database to support my son’s customer focused business, which is Tree Surgery, and to refine it later into a more complex model.
The system now includes his customers, work lists, risk management, invoicing and accounts.
A simple dashboard gives accurate up to date information, vital for work planning and financial management. We use the calendar, with colour coded text for daily work planning and emails linked to buttons for quotes, invoices and receipts. Review collected by and hosted on G2.com.
The calendar can get cluttered and the facility to have more than one calendar available would be useful. If individual calendars could be created for example for quotes, work lists and plant maintenance due dates, would add a potentially very live feature. Review collected by and hosted on G2.com.
The Tree Surgery business requires good customer interaction linked to good risk management work records. Ninox has allow us to the create tables, views and printed reports to support the essentials of our business.
Using historical records we can now provide more detailed analysis of current work loads and monitor the financial impacts of business decisions.
By creating tables for hazards, risks and method statements and linking these to individual jobs we are reducing the risks to staff and customer in what is potentially a high risk business.
Accurate records for purchases and well as invoices means we have better control of finances and a live view of tax due. Review collected by and hosted on G2.com.
This is undoubtedly the best database system, the capabilities it offers for data manipulation, it's the way of accessing the data and its architecture guarantees that the information is always safe and available, multiple tools to enhance the functionalities that are integrated with this database engine, such as Grid Infrastructure, ASM or Data Guard, likewise the amount of documentation and support guarantees a product that lasts.
I have solved data storage problems for web applications, I have carried out data assurance processes through high availability policies, combining Data guard with the oracle database, also cluster solutions have been configured to guarantee a database system of distributed data, this to help in the availability of the information
Likewise, there are advantages when creating the different data structures, this due to its memory optimization algorithms, and its ability to optimize the queries that are handled, automatically tuning the queries that are being generated. This helps to have a quick and consistent response with the information that is required.
It is also worth highlighting the management of geographic databases that rely on the speed and precision with which said data is handled, this allows its use in many areas such as geolocation, auditing, and security.
Also noteworthy is its ability to perform backup processes with the RMAN tool, this helps us periodically generate backup and restoration processes to be able to secure the organization's data, this as information retention and assurance policy.
Finally, I worked as advanced support on this type of products, which allowed me to see their interaction with other tools in the Oracle suite, it is worth highlighting the immense amount of integration tools that allow expanding the functionalities according to business needs. Review collected by and hosted on G2.com.
One of the negative points is the price of this database engine since it is around US $ 5,995 for the standard version, it also depends on the size of the project, you can make the decision to obtain it from other free engines such as MySQL or PostgreSQL.
Likewise, another negative point may be the initial configuration of this type of solutions since they require advanced support advice to be able to configure the different tools that are going to be integrated, there is clear and specific documentation to perform the installation on-premise, but Sometimes an advanced knowledge of OS and middleware is required in order to install DB monitoring tools.
Likewise, the price on the support of the products and the licensing on volume at times has maintenance and membership charges, this makes the costs exponential Review collected by and hosted on G2.com.
For the Oracle database service implementation process, you must have clear expectations and data retention policies from the beginning, it is also a good idea to rely on the step-by-step installation guides to be able to perform the configurations necessary, it is also recommended to have spark as the operating system since it comes with implemented improvements that help improve the performance of the relational database Review collected by and hosted on G2.com.
I have solved data storage problems for web applications, I have carried out data assurance processes through high availability policies, combining Data guard with the oracle database, also cluster solutions have been configured to guarantee a database system of distributed data, this to help in the availability of the information Review collected by and hosted on G2.com.
XDR super easy replication is my #1. Super easy to set up, you choose what and where to replicate.
Additionally, software has the possibility to fully utilize some cloud providers and their services, which is giving this software huge advances..
I loved shadow devices and lastly but very importantly, every time I contacted support it was a great experience. Review collected by and hosted on G2.com.
Honestly, the software is properly built and I haven't founded its downsides yet, As soon as I do, will write a new review. Review collected by and hosted on G2.com.
I used it as great replacement for Memcached, as I needed some good replicated solution, and Aerospike has it all in one software, I one namespace configuration...
Additionally, for setup to support 10k I/O per sec, you need around 5 hours - if inexperienced with software. Review collected by and hosted on G2.com.
If you want to be self-dependent, not a slave of any cloud-managed service, you can have a super-fast database for a fair price including maintenance. Review collected by and hosted on G2.com.
Amazon ElastiCache offers fully managed Redis and Memcached. Seamlessly deploy, operate, and scale popular open source compatible in-memory data stores. Build data-intensive a
Not much modification required to move our existing redis cluster onto the Amazon ElastiCache. What I love the most is Multi-AZ failsafe architecture available to set up our Redis cluster here. Also it is very fast and easy to manage through the AWS console. Review collected by and hosted on G2.com.
Not complaining, but it feels the pricing structure for the usage is pretty high. Review collected by and hosted on G2.com.
Initially we had our redis cluster set up on a single EC2 instance. Since it is a startup we couldn't afford a bigger instance at that time. So everyday during our peak times the instance used to fail due to overload. We had a trial run with moving the redis cluster to Amazon ElastiCache and use the multi-AZ failsafe architecture. Initially it was a 3 node failsafe architecture. Right out of the bat, it was a hit. We immediately moved our production cluster on to it and never got to worry about it any other day. Review collected by and hosted on G2.com.
IBM® Db2® is the database that offers enterprise-wide solutions handling high-volume workloads. It is optimized to deliver industry-leading performance while lowering costs.
They provide DB2 as a RDMBS with many features and easy of use. It has powerful SQL features especially for mainframe system is very beneficial. It is a great cross platform database as can be run on any server. Especially great for mainframe users. Review collected by and hosted on G2.com.
I guess that it is not much marketed by IBM and the new version of Db2 are not rolled out as quickly as some of its competitors. Also paid IBM support is very much required. Review collected by and hosted on G2.com.
IBM Db2 is used for storing most of our business data very securely. We have been able to perform migration from other databases to Db2 effectively using some of the utilities provided by IBM as part of DB2. It is very much self managed database. Review collected by and hosted on G2.com.
ArangoDB is a distributed, free, and open-source database with a flexible data model for documents, graphs, and key-values. Build high performance applications using a conveni
The AQL query language is the best by far.
What I also like a lot is that you can start using arango as a replacement for mongo and progressively as the project scales you might need the search or graph etc so no extra database is needed, and that's awesome! Review collected by and hosted on G2.com.
What I don't like is the fact that if you want to start using the cloud version, you have to go to a paid version from day one.
There should be a free tier for people to play around for very small projects.
AWS, Google etc have free tiers for their databases to attract more developers to use their services. Review collected by and hosted on G2.com.
For me, what I found great is the ability to make complex queries very easily using AQL. Also what is great is that you combine multiple database types into one. Review collected by and hosted on G2.com.
I like that it gives the flexibility to design both SQL and Sharepoint front-ends as well as stand-alone apps. Because it is fairly ubiquitous and has a free runtime version, Microsoft Access is a great platform for developing databases for use across the organization. Review collected by and hosted on G2.com.
I am not happy that the most recent versions of Access eliminated the ability to do pivot graphs. A number of my databases had dashboards that now must be completely redesigned. Review collected by and hosted on G2.com.
Access no longer requires quite so much reliance on VBA as it used to; nevertheless, it takes a while to learn, and not all of its features are particularly well documented. Review collected by and hosted on G2.com.
I use this product for everything from end-user applications to analytics tools for my own use. I've been able to consolidate multiple Access databases into single applications, reducing the number of data silos and giving more users direct access to their data. Review collected by and hosted on G2.com.
One of the main Amazon DynamoDB advantages in my opinion is the pricing model based on data read and writes instead of the volume data. Basically you do not care about the amount of data you are storing into the database.
Besides that, the integration with Amazon DynamoDB in your application is quite simple. Even if there is not a SDK available for your application platform, the communication with the database is via HTTP requests, what turns the integration easy to implement. Review collected by and hosted on G2.com.
The documentation is not simple to follow. There are many co-related pages linked each other, sometimes describing the same information. I think it is just a matter of bad organisation. In general, all the information you need about how to use Amazon DynamoDb is there, the difficult part is to find what you are looking for. Review collected by and hosted on G2.com.
Amazon DynamoDB is a serverless database solution, that means you do not need to provision, operate and maintain databases, like traditional database solutions. Your work basically is just to define the tables and start using. Moreover, scaling and fault-tolerance are built in features. Review collected by and hosted on G2.com.
Amazon DynamoDB is used in my application mainly for two different features:
- As a transactional database
- As a temporary storage for data with a defined TTL (time to live)
In both scenarios above the structure of tables are defined as document database. Review collected by and hosted on G2.com.
The best thing about AWS RDS is that it support various types of databases including widely used MySQL, so one can easily migrate their existing or new database(s). The other best feature of AWS RDS is it's availability, it is one of the best when compared to it's competitors. It is secured to manage the relation database of both website(s) or app(s). Review collected by and hosted on G2.com.
It's not so easy to setup or manage from the AWS console, specially for the beginners. Sometimes messing up with the security group may end up with stopped functionality of the whole database. Review collected by and hosted on G2.com.
If you have small DB, don't go for it. Review collected by and hosted on G2.com.
We are using AWS RDS to store the website's backend database at the same. It's very fast and feasible to fetch and manage the data with AWS RDS. We are using MySQL DB. Review collected by and hosted on G2.com.
I use the Redis API in my python web-stack and it is one of the slickest things I have ever had the pleasure of working with. The application that I maintain, deepquill.com, needs to serve a high volume of requests while doing continuous cloud-resource tracking/management and it all has to happen asynchronously, so naturally I turned to Redis for a high speed caching solution. At the time I knew only Postgres and Redis works very differently, so I was new to the whole system. The solution I needed to implement with this database wasn't exactly trivial either, so I was prepared to spend a good amount of time slogging through source code to learn what I needed to alter to get this module to work how I wanted it to. -- To this day I have not seen a single line of it's source code -- It's all there in the documentation, written in plain English with examples and use-cases galore! Even if there were a faster and more reliable caching solution on the market (which there isn't) , I would honestly still pick Redis if only for it's thorough and accessible documentation. Review collected by and hosted on G2.com.
The only downside I could identify with this solution is that it is not really meant to store data in a persistent form. At least not by default. Redis does everything in volatile memory (which is why it can be so fast) , and while it is easy to set it up to write your data to disk from time to time (it's maybe 3 lines of code tops), it can potentially be confusing to people who come from a more traditional database and expect their data to still be there after a power cycle. The only people who would really suffer from this misunderstanding are those didn't read the manual though, so don't be one of those and you'll be fine. Just be warned: if you want Redis to record your data in a persistent form, you have to explicitly tell it to do that. Review collected by and hosted on G2.com.
If you are trying to control a secured Redis server using a shell script you want to use a "-a" flag followed by the password. This was the only thing I've found that wasn't explained in the documentation. But now you know! Review collected by and hosted on G2.com.
I needed to keep track of user activity, resource utilization, message caching, and the status of many containers on many AWS EC2 instances with high time-resolution, and manipulate all of this data in such a way as to make it easy to tell when to do what with which resource (margins are slim so we want to be as efficient possible) Redis handles ALL of this for us and deals with asynchronous operations in a most sane and predictable way. Redis also lets us encrypt all of our data moving between layers, which is pretty badass in my opinion. Review collected by and hosted on G2.com.
I love Amazon Aurora, it is a great solution that supports my managed database systems, MySQL and PostgreSQL compatible, built for the cloud, providing me with multiple read replicas and I don't need to worry about capacity and performance. Review collected by and hosted on G2.com.
It is a bit expensive compared to the other available solutions, but considering its characteristics it is a good option as it is very cost effective when used with the proper configuration. Review collected by and hosted on G2.com.
Aurora is actually very fast when it comes to executing a large number of queries, increasing its overall performance, which helps me a lot in my workspace. Review collected by and hosted on G2.com.
Aurora is actually very fast when it comes to executing a large number of queries, increasing its overall performance, which helps me a lot in my workspace. Review collected by and hosted on G2.com.
As an entry point into NoSQL, Couchbase is great. Setting up a cluster was amazingly easy. I almost felt like I had installed Chrome. The web interface also is quite rich, and easy to use, and it has built in monitoring so you can see how well it is performing. We looked at mongo, but it was more difficult to set up. We also have found Couchbase to be quite fast. It also integrates well with our windows environment and with .Net as well. We had already migrated our apps into a Service Oriented Architecture and Couchbase slide right in. Also the plug-in with ElasticSearch greatly increases the power of Couchbase giving you a premier search index on your data. The community is also quite vibrant and a good source of help. Review collected by and hosted on G2.com.
Documentation is pretty thin. What is available is well written but not deep enough. Also to determine which design patterns for your data documents to use is missing. They leave you on your own, and it is not clear how to fully leverage the product with your design. N1QL is coming out, but without it to find data in your buckets you have to write code. Also the web front end will not display large documents so I had to write a front end to see a lot of my documents. Also when updating the OS for nodes in my cluster is a pain. The failover process can get hung up with unclean virtual buckets and you have to write code to populate all 1024 v-buckets so that they will balance properly otherwise it will get stuck Review collected by and hosted on G2.com.
The product is very simple to setup. But knowing how to structure your data is a real challenge. This challenge exists for all SQL to NoSQL conversions. I strongly suggest using the ElasticSearch plugin. Review collected by and hosted on G2.com.
Search Search Search. With Elasticsearch as our index and Couchbase as a store we now have awesome search capabilities. Review collected by and hosted on G2.com.
SQLite is the fast ad small database, ideal for small or big application (web, mobile, server or desktop).
Don't require a server software and the DB file is portable to other platforms (Windows, UNIX, etc).
Most popular software use SQLite (eg. yum repositories, Firefox, Tenable, Android, etc.)
Cover most of SQL syntax and it's possible to create table, view, index, virtual table (eg. from a csv file or from a directory) and custom functions (via programming language).
SQLite is supported by PHP5, Perl, C, Tcl, C++, C#, Python, Rust, and more programming language. Review collected by and hosted on G2.com.
SQLite not offer built-in security facility (eg. login, ACL and encryption) Review collected by and hosted on G2.com.
SQlite is the best choice for application prototyping and for redistributable application Review collected by and hosted on G2.com.
SQLite is ideal with environment with less space or memory Review collected by and hosted on G2.com.
Informix is best database for OLTP, Enterprise Replication & High Availability
It is Solid & Stable, Best performance, Minimun administration
It runs without problems with almost all versions of Linux, Unix & Windows (even android)
It is Mulituser, Multiprocesing, Multithreading, Parallel Procesing, MultiServer.
Informix is true 24x7 services.
Informix is true Oriented Object Database
Free Support Groups of Informix (They are friendly and open mind)
Now Informix have new technology like Nosql & Json
Development is easy with 4gl & Eclipse (Java) Review collected by and hosted on G2.com.
When IBM don't see true value of 4GL
Don't exist a unique tool to access to no traditional data like text,blob,spacial,json/bson and others
Sometimes There is not enough technical support in my country Review collected by and hosted on G2.com.
This database have the best ROI
The performance is the best
The maintenance & administration is minimum
Exists a version of informix for any plataform even for android
You can Use Enterprise Replication with hundred servers without problems
You have on-line documentation
You have free groups for support the database. These groups are friendly like a family Review collected by and hosted on G2.com.
Implementation of 4GL-ERP Solution. This ERP solution is used in OLTP environment
Data Distributed and High Available using Enterprise Replication and High Data Replication. We have many servers interconnect. We have almost one hundred servers on-line with ER (Enterprise Replication)
Heterogenous environment using Linux, Unix & Windows
Work with documents and images, We have a repository of XML and PDF files inside of database.
Web Solution: The users enter the customer orders with control of portafolio of products and budget by departament.
Electronic documents using WebServices
Development with free tools like java & Aubit 4gl. Review collected by and hosted on G2.com.
The most helpful thing is that it eases out the work you do. The upsides of using hbase is the user friendliness that it provides. This technology is gaining a lot of importance these days.
Other helpful features are a variety of commands that it provides. Apart from that you would explore a lot of upsides when you actually start working on this great and helpful technology.Since hbase is a no sql database so the users dealing with massive data or big data will find it really helpful to work with hbase. This technology is a great upside in this field and certainly gonna be a leader on upcoming days. When you are dealing with a huge velocity and volume of data this technology comes out to be a saviour. I highly recommend use of hbase instead of conventional technologies. Review collected by and hosted on G2.com.
The least helpful about hbase I think is the lack of some common features that are available with similar technologies available in the market. The downsides of hbase hence could be improved. For a technology to become popular the least helpful needs to be ommited out and the downsides could be removed. Technologically I found out that when only one Hmaster is used, there could be a possibility of failure. Since joins are handled in MapR layer. Since a traditional RDBMS is index on multiple columns Hbase is only index on a key. Review collected by and hosted on G2.com.
For those looking at hbase, First of all you should have a prior knowledge of the traditional rdms systems then only you would be able to make the best out of it. These big data systems are really helpful and gaining a lot of popularity. Review collected by and hosted on G2.com.
Hbase has impacted by work significantly in the past 2-3 years. The use of hbase has made me deal with the unstructured data in a much more convenient way than I used to struggle with other technologies. For a technology to make a huge impact it should be usef friendly enough and hbase has left no stone unturned except a few :). Hbase is a one stop solution for dealing with data problems. So you name a data problem and hbase has a solution. It has significantly impacted users across the world. Review collected by and hosted on G2.com.
Simplicity (Portability, Management) and Efficacy. I like also compliance of ASNI standards for SQL. It is easy to get a snapshot, just stop database engine, copy a file and start database service one again. Managment is as simple as it could be. There is one tool for user management, other one to backup and restore a database. It is very flexible, powerful database engine and it doesn't use much of system resources. I hope You take this into consideration. Review collected by and hosted on G2.com.
Efficacy problem with large volume of data (above 3-4GB), poor recoverability after database corruption. I don't like the archives incompatibilities between 2.x and 3.x branches. I also dislike a lack of window function in 2.x version. I would be great if there is official database explorer like SSMS or SQL Developer. I also feel lack of server linking technology to connect multiple cross-platform database to firebird. Review collected by and hosted on G2.com.
It's great on premises database for all of propose if only You don't need to store more than a couple of GB per one datafile. I works with many RMBDSes but I belive that Firebird is unique and worth of using in every inch. I advise You to give a chance to Firebird becuase if You start use it, You would love it :) Review collected by and hosted on G2.com.
I use Firebird mainly as database behind selling and storage system for Pharmacies. The second possible database engine for this application is Oracle but I prefer using Firebird. I also write SQL statements for data extraction from OLTP Pharmacy's databases. Review collected by and hosted on G2.com.