SQLite 사용 후기 및 리뷰

Perfect database tool for embedded software

주석: I work a lot with SQLite as it is the primary medium of local storage in Android devices (and by extension, Android applications) which I work with on a daily basis, and SQLite is just perfect for the purpose it serves on these devices. It's lightweight so you don't have to worry most times about how much of the user's storage space your database is going to take up. There's not much difference between the standard SQL commands and those used in SQLite, and many have reported that SQLite is a good starting and training resource for SQL in general.

장점:

Doesn't need a separate server. Lightweight and portable. Integrates most of the commands, functions and syntax of other SQL software. Optimized for use on devices that need to store data locally. Large user base and community (support).

단점:

All operations are locked to a single process, so it's not suitable for large scale database operations (which is not what you should be doing locally on a device anyway).

Power in the simplicity

주석: Works very well in simple scenarios! It might be a great choice for small applications that require low maintenance and easy setup

장점:

It's very simple to use and lightweight. Typically does not require a separate server (it could run on the same server as a web application). It's quite handy that the database is contained in one file, which then can be backed up easily or transferred across machines. It's quite fast for certain uses.

단점:

Compared to other RDBMSes, it's very simple - which means that it's lacking certain features when it comes to scalability - it performs well in simple scenarios, and in complex ones - it just won't (unless you are very lucky and it's e.g. a case when there is only a single connection).Moreover, it lacks certain security features like user management and access control.

SQLite - compatability at it's best level

주석: SQLite has become more and more popular among the users because of its easy installation and easy accessing . As it is compatible with most of the programming languages and its light weight it is more popular among mobile application developers

장점:

SQLite is a light weighted data base which could be embedded with any software. Due to the light weightage of the product the data base is more popular In mobile application development. With it’s light weight it is also fast. SQLite is almost 35% faster than any other file system. SQLite is easy to use and there is not special installation or configurations needed to be done in order to use the product. All user have to do is download the libraries and run them in the computer. It is compatible which is why the product can be used with many programming languages with out any issues. Users are given a chance to extend their data base in future by adding new tables or new columns to the existing tables which is a great help for the ongoing projects.

단점:

SQLite is not a multi-user platform where the users can handle concurrent writes. There for SQLite is not good for intensive applications with rapid data logging. If the system has concurrent transactions where lot of users keep accessing the same set of data simultaneously then SQLite is not a good choice for the project. SQLite data bases are restricted to maximum of 2GB in most of the cases.

An excellent database for mobile projects

주석: I have used this database for the development of mobile application projects and for the prototyping of web pages, which makes it a very good database, easy and agile when manipulating data

장점:

What I like most about this product or database is how easy it is to integrate with mobile projects in the creation of applications and its easy portability, as well as performance, agility and little space in its implementation that makes it unique when it comes to of mobile application projects

단점:

That for very large projects it is not so robust handling so many transaction threads

The best database management

주석: I've been using SQLite to store databases and manage them easily. It's a fast and light tool, which helped me in several different cases.

장점:

It's light (doesn't require much resources), fast, it's stable, cross-platform. It's a free and open-source software which helps a lot with saving money and making sure it's secure.

단점:

It's not recommended for big databases, only for small ones.

A useful, yet untidy tool

주석: quick to deploy and simple to implement, although certain users may want to be aware of some UI and security concerns.

장점:

Very simple to use and undoubtedly reduces the amount of physical memory used

단점:

Some security issues and occasionally non-loading user interface parts make me doubt its reliability

Experience with SQLite

주석: Describe your general experience with SQLite
It is very useful for me to be able to store information and consume it from different sources without having to implement specific software to do so. Its portability capacity has allowed us to distribute work effectively.

장점:

The few resources you need and its portability. This allows us to use the stored data from any medium.

단점:

That there is no native way to make it multi-user. That there is no native way to merge files from the same database, when they have been modified by different users and platforms.

SQLite: The best Database ever

주석: It is an excellent database as compared to others. I do not see any database competing with SQLite

장점:

SQLite operates with lightning speed. It is the compressed version the MYSQL. It is extremely efficient in website management and many other managerial tasks in any organization.

단점:

It is very complex for beginners, but easy to understand.

The best solution for small, pre-packaged databases

주석: We included SQLite alongside web and mobile applications where a small database was needed with minimum latency. Most commonly, this use case involved storing dynamic configuration values and user preferences.

장점:

SQLite is a great database solution when you have a small database that you need to package alongside an application, for example a database that stores user preferences. As it is local to the application, it bypasses issues you would have with other, larger database servers in terms of network latency. Its conformity (in the large part) to MySQL syntax and features make it easy to use as well.

단점:

While SQLite's lack of scaling features is forgivable (that wasn't what it was built for after all) some SQL features that are not implemented make it a hassle to write queries to SQLite databases in some instances.

A lightweight relational database management system especially for offline mobile applications and d

주석: We have used SQLite in developing many mobile apps, mostly Android App and as a database at back end we integrated this light weight DB system. The processing speed of queries is exceptionally fast. All the databases are working well.

장점:

SQLite is object based relational query language which keeps and maintained the whole databases in a very light weight, usually within 500kb to 1mb size, depending on size of databases. This database system has everything which a standard databases must have like relationships, events, all operations, etc. SQLite is very helpful in building application for Mobiles which stores databases in locally.

단점:

1. No dedicated server required. 2. Very light weight and easy to follow commands with knowledge. 3. Large community support makes learning this language even more fast and easy 4. Easy to keep backups as the whole database stored in single file. 5. Easy to implement and integrate.

A standard for testing

주석: SQLite allows us to setup and test all our database structures, it's quick and easy to get going and it stays out of your way. Most of the time you'll forget that it's even part of your tech stack.

장점:

I like that SQLite for the most part stays out of your way. As soon as you have your desired config set up, you can transfer it with ease to most other projects and it just works. We use SQLite for testing purposes as it speeds up the entire process. You can either spin a local instance up or have it run in-memory to speed up your tests. The fact that it's usage is so ubiquitous, finding help or answers online isn't an issue at all.

단점:

If I had to fault it at something, there is an edge case with how it builds your database structure, especially with how it handles foreign keys. It's easily handled by adjusting your test setup structure. That's the only hiccup we ever had and resolved with ease.

My SQLite Experience

주석: Its average in my opinion. The data management are good but complicated

장점:

The using of tools, tables and manage datas

단점:

The less functions compare other programs(etc. SSMS)

Best Lightweight Relational Database for Small Applications and Websites.

주석: We always use SQLite as our database when building software and web application prototypes and when deploying basic websites and apps that are not data-intensive.

장점:

SQLite does not run on a server like MySQL but is part of the end application thus making data storage and retrieval very fast.

단점:

It is not reliable when deploying it with applications with multi-user access to database. With websites, SQLite can only handle sites with low to medium traffic.

Very good local database.

장점:

We use it in our software when we need little local database. The API with c# is very easy to learn. I recommand this if you need local database.

단점:

There is no data viewer include. You need to find an alternative.

Database easily with SQLite

주석: I used this application to learn database systems. I transferred the excel data I had, created tables, and transferred this data to the external environment with an external connection.

장점:

The application is very easy to use. The interface is simple and user friendly. The convenience of the download process is amazing. Very little space on the computer

단점:

There is nothing wrong with the application, it is suitable for learning purposes.

Small business helper

주석: Overall SQLite is good software in its field that can help greatly.

장점:

SQLite is suitable for small companies that doesn't have big databases. SQLite handles small data very easily. It doesn't load the computer. And is relatively easy to use.

단점:

As i mentioned SQLite is comfortable for small databases. But won't be affordable for large amount of data.

fast flexible database with robust features

주석: SQLite works great for our specific use case as we prefer performance over HA / concurrency.

장점:

Extremely portable and fast ACID store. SQLite is very battle tested and highly performant. There are many bindings for various programming languages which makes it easy to get started with. If you couple SQLite with fast SSD, the performance is incredible (since it's just a file). Backup and restore is super easy and fast.

단점:

SQLite is for a very specific use case and there are no distribution properties or guarantees. Designed to be very simple so not a lot of tuning for SQLite. If you want high availability and concurrency, you may want to look at a different solution.

SQl lites is very helpful company

장점:

Sql lite is eaay to use and the built are function is alo very good it helps me to save my time. The best i like is the supporting multiple languages like drupal and python

단점:

I like the least is supporting the multiple languages because i an a data analyst student and for that i need data which is store in database and i can arange the data in order

Depends on how you store your data

장점:

If you are storing variable data that resemble objects, use this instead of MySQL! There are also a lot of libraries built for accessing and manipulating SQLite databases now.

단점:

It takes up much more space and memory compared to conventional databases like MySQL

Database on the go!

장점:

SQLite is a great solution when your application needs a small footprint database with all the powers from relational SQL. It integrates with any language you need and is available in any platform!

단점:

Being a smaller library, it misses some features from bigger database systems.

Invaluable offline database

장점:

SQLite is great for rapid applications development and testing out how your application works without having to connect to a server. It serves as a decent local cache of data.

단점:

Understandably not suitable for large data content

A must for BI

주석: Used SQLite for querying a relational database at work. Once you learn the basic syntax, it becomes fairly easy to use.

장점:

Once you figure out syntax, there is no better language for writing queries to a relational database. SQL is the measuring stick

단점:

Like any language, there is a learning curve (albeit not as bad as most others)

Easy to use Database

주석: Overall I'd say my experience with using SQLite in school has been fantastic. It's easy to pick up and use, lots of features, easy to use software that allows you to connect and create databases as well.

장점:

SQL is pretty easy to understand. The syntax is common words so you can figure out what the code is trying to accomplish very easily.

단점:

Learning the language can be confusing sometimes if you don't know where to go.

My favorite file-based database

장점:

Reliable SQL relational database meets file-based database. Those cases where you need some modest relational data access, but don't need or can't accommodate a full RDBMS server instance. The small footprint and portability makes SQLite a great choice for small applications.

단점:

Can't be as feature rich as a full blown server application. More of a trade-off than a con.

Database small and effective

주석: If you need a small and robust DB it is the right choice

장점:

Given its size, it is almost an obligatory choice for small databases to be distributed, for example through an app. The latest releases have also made it very robust.

단점:

From the name it is clear that the database is not designed to accommodate large amounts of data, so we need to evaluate the adoption well.