适用于 Linux/Windows 的轻量级 SQL 服务器?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/1023785/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-15 12:40:48  来源:igfitidea点击:

Light-weight SQL server for Linux/Windows?

linuxdatabasewindowssqlite

提问by Gulbahar

SQLite is fine as a single-access database, but it gets risky when used by more than one user at a time. MySQL, Firebird, PostgreSQL etc. are more difficult to deploy and are simply overkill for my use.

SQLite 作为单次访问数据库很好,但如果一次被多个用户使用,它就会有风险。MySQL、Firebird、PostgreSQL 等更难部署,对我来说简直是矫枉过正。

Ideally, I'd like a compact, single-EXE server meant to run on low-spec hardware (eg. 128MB RAM, 256MB flash RAM) that would be as easy to work with as SQLite, and is available for Linux (and Windows, so I can use the same code client-side in case customers prefer a regular PC.)

理想情况下,我想要一个紧凑的单 EXE 服务器,旨在运行在低规格硬件(例如 128MB RAM、256MB 闪存 RAM)上,它与 SQLite 一样易于使用,并且可用于 Linux(和 Windows ,因此我可以在客户端使用相同的代码,以防客户更喜欢普通 PC。)

Do you know of an application that fits those requirements?

您知道符合这些要求的应用程序吗?

采纳答案by Ertugrul Kara

Give Firebirda try. It's cross platform and lightweight. Databases consist of single files.

火鸟一试。它是跨平台和轻量级的。数据库由单个文件组成。

回答by Anupam Maiti

Try H2,Its a Java based SQL database engine.....

试试 H2,它是一个基于 Java 的 SQL 数据库引擎.....

  • Very fast, open source, JDBC API
  • Embedded and server modes; in-memory databases
  • Browser based Console application
  • Small footprint: around 1.5 MB jar file size
  • 非常快,开源,JDBC API
  • 嵌入式和服务器模式;内存数据库
  • 基于浏览器的控制台应用程序
  • 占用空间小:大约 1.5 MB jar 文件大小

回答by Stefan Mai

You might try looking at Apache Derby (http://db.apache.org/derby/). It's Java, so it'll be portable and it's definitely lightweight.

您可以尝试查看 Apache Derby ( http://db.apache.org/derby/)。它是 Java,所以它是可移植的,而且绝对是轻量级的。

回答by Alex

Another option is HSQLDB. It's light, fully Java and multithread. I used in personal projects with very good results.

另一种选择是HSQLDB。它很轻,完全是 Java 和多线程的。我在个人项目中使用,效果非常好。