Durchschnittliche Bewertung

64 Bewertungen
  • Gesamt 4.5 / 5
  • Benutzerfreundlichkeit 4.5 / 5
  • Kundenservice 3.5 / 5
  • Funktionen 4 / 5
  • Preis-Leistungs-Verhältnis 4.5 / 5

Produktdetails

  • Startpreis 0,00 $
  • Kostenlose Testversion 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.

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.

Easy to become a problem

Bewertet am 8.11.2018
Anderson M.
Senior Software Engineering
Informationstechnologie & -dienste, 201-500 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Quelle des Nutzers 
4/5
Gesamt
3 / 5
Benutzerfreundlichkeit
2 / 5
Eigenschaften & Funktionalitäten
3 / 5
Kundenbetreuung
5 / 5
Preis-Leistungs-Verhältnis
Wahrscheinlichkeit der Weiterempfehlung:
Unwahrscheinlich Äußerst wahrscheinlich

Kommentare: On a Windows Forms app we used to query services thousand times for data that does not change so frequently. We also had to store some business information (imagine as storing a wizard progress) and that used to be handled using TXT files (and it was a mess). We changed to SQLite and it worked almost like a charm but as the app grew and we decided to create an architecture similar to Google Chrome (multiple processes) it became a major problem for all of them to both read and write at it (we had to create a proxy app to write).

Vorteile: Integrates nicely with .NET (specially Windows Forms) applications, it's really easy to use (specially if you're already familiar with SQL Server) and deployment is really easy (copy/paste required files).

Nachteile: It's locking architecture enables only a single process to write at a time so building a more complex application may cause hard-to-solve problems.

Lies weitere Bewertungen