Durchschnittliche Bewertung

66 Bewertungen
  • Gesamt 4.5 / 5
  • Benutzerfreundlichkeit 4.4 / 5
  • Kundenservice 3.7 / 5
  • Funktionen 4.1 / 5
  • Preis-Leistungs-Verhältnis 4.4 / 5

Produktinformationen

  • Startpreis 0,00 $
  • Gratis Testen Nein
  • Einsatz Installiert - Mac
    Installiert - Windows
  • Kundenbetreuung Online

Angaben zum Hersteller

  • SQLite
  • https://sqlite.org/

Über SQLite

Datenbank-Management-Lösung in einer C-Programmierbibliothek.

Spotlight_media_placeholder

SQLite Funktionen

  • Backup und Recovery
  • Datenbank-Umwandlung
  • Datenmigration
  • Datenreplikation
  • Leistungsanalyse
  • Mobiler Zugriff
  • NOSQL
  • Relational
  • Unterstützt zahlreiche Programmiersprachen
  • Virtualisierung
  • Zugriffskontrollen/Berechtigungen
  • Abfragen
  • Datenbank-Umwandlung
  • Datenmigration
  • Lageroptimierung
  • Leistungsanalyse
  • OLAP
  • Sicherungskopie
  • Überwachung

Die hilfreichsten Reviews für SQLite

A standard for testing

Bewertet am 14.9.2019
Gareth N.
Web Developer
Computer-Software, 13-50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Quelle des Nutzers 
5/5
Gesamt
4 / 5
Benutzerfreundlichkeit
4 / 5
Eigenschaften & Funktionalitäten
Kundenbetreuung
Preis-Leistungs-Verhältnis
Wahrscheinlichkeit der Weiterempfehlung:
Unwahrscheinlich Äußerst wahrscheinlich

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

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

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

Reliable and battle tested database engine

Bewertet am 9.12.2019
Thang N.
Senior iOS developer
Informationstechnologie & -dienste, 51-200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Quelle des Nutzers 
5/5
Gesamt
5 / 5
Benutzerfreundlichkeit
4 / 5
Eigenschaften & Funktionalitäten
Kundenbetreuung
5 / 5
Preis-Leistungs-Verhältnis
Wahrscheinlichkeit der Weiterempfehlung:
Unwahrscheinlich Äußerst wahrscheinlich

Kommentare: I had been using it for Windows, iOS, backend and Android for many purposes. The support for sqlite always straight forward. I would recommend sqlite for tasks which not use joins nor store procedures. Native security is quite weak without supporting encrypt particular table or column.

Vorteile: Lightweight relational database, works on many platforms and has gain support from popularity in community. The toolkit for developing is great and easy to understand the concept. Integration to mobile is a nicer experience compare to other db engine. The speed and datasize is good for mobile as well.

Nachteile: We need to define data structure first before actually implement features, any mismatch in database scheme must be resolved using migration. The locking architecture only allow a single process to write at a time - no high volume transaction - and it isn’t able to scale to hundreds of users nor store large amount of data.

Perfect database tool for embedded software

Bewertet am 22.3.2019
Stephen O.
Lead Android Developer
Computer-Software, 13-50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Quelle des Nutzers 
5/5
Gesamt
5 / 5
Benutzerfreundlichkeit
5 / 5
Eigenschaften & Funktionalitäten
4 / 5
Kundenbetreuung
5 / 5
Preis-Leistungs-Verhältnis
Wahrscheinlichkeit der Weiterempfehlung:
Unwahrscheinlich Äußerst wahrscheinlich

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

Vorteile: 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).

Nachteile: 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).

No server required, used for standalone application and less configuration

Bewertet am 25.4.2019
Verifizierter Rezensent
Software Engineer
Telekommunikation, 13-50 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Quelle des Nutzers 
5/5
Gesamt
4 / 5
Benutzerfreundlichkeit
4 / 5
Eigenschaften & Funktionalitäten
4 / 5
Kundenbetreuung
4 / 5
Preis-Leistungs-Verhältnis
Wahrscheinlichkeit der Weiterempfehlung:
Unwahrscheinlich Äußerst wahrscheinlich

Kommentare: We are using SQLite for java and android application. SQLite is use for small and mid level organization as well because its cost affordable for any one. There is no required to back up every time because SQLite make a file for backup .

Vorteile: SQLite is very faster then other database as performance wise. we are using SQLite for mobile application and desktop application. Mose imp feature i like in SQLite is at the time of deployment on production it not required any space. SQLite is lightweight. select query is very faster in standalone application.

Nachteile: There is no reporting functionality in SQLite. At the time of multiple insert query perform in queue that its goes slow for some time. There is administration in SQLite,so its very difficult to manage for multiple user.

Great Database For Smaller Loads

Bewertet am 3.10.2019
Verifizierter Rezensent
General Manager
Informationstechnologie & -dienste, 2-10 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Quelle des Nutzers 
5/5
Gesamt
5 / 5
Benutzerfreundlichkeit
3 / 5
Eigenschaften & Funktionalitäten
Kundenbetreuung
Preis-Leistungs-Verhältnis
Wahrscheinlichkeit der Weiterempfehlung:
Unwahrscheinlich Äußerst wahrscheinlich

Kommentare: This is definitely a great option when we are working on smaller projects that require and embedded database rather than the whole database setup. You quickly get up and running but security is definitely a concern when working on more sensitive work

Vorteile: It doesn't required installing an extra software.
Provides the essentials in terms of structured query language which is often better than having to use a text file, especially when relations are involved.
It is very cross-platform from mobile, desktop etc which makes life easier.

Nachteile: When it comes to systems that may have a lot of concurrent actions it, in my experience, often tends to lock up.
It doesn't give much in terms of allowing to tune performance for more complex scenarios.
There is no user management in place thus there are not permissions, it may not be the best option for more sensitive data
Last I checked there was no date data type which means enforcing that date formats conformity is often on the developer's side.

Lies weitere Bewertungen