适用于 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
Light-weight SQL server for Linux/Windows?
提问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
回答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,所以它是可移植的,而且绝对是轻量级的。