Hi,
I'm a little new to Rust and have been trying to scan the ecosystem for something particular. I'd like to work on some basic server based games, particularly MUDs but also maybe simple web servers for the backend of a game.
Anyways, is there any good embedded DB's out there for Rust that can actually be persisted to disk instead of just in memory? Hopefully that aren't too complicated and ok for a bit of a toy project?
I’m currently doing my A-level computer science project where I’m creating a social media platform I am using Intellij Idea’s feature of the embedded database and I am coding in Java, with the database in SQLite. However, I am having issues with calling and searching the database as I have only been coding in Java for a short amount of time. I have researched online but it has not been much help as everyone does it differently, and none of the methods use the embedded database feature. Does anyone have any advice on how to actually call, connect, and search my database?
This is my code where I am trying to connect and search my database which is broken
@Override
public void actionPerformed(ActionEvent ae) {
if (ae.getSource() == createButton) {
this.dispose();
new Create();
}
Connection conn = null;
try {
String url = "jdbc:sqlite:/Users/user/Desktop/A-LEVELS/COMPUTING/ProjectAppGui/Users";
conn = DriverManager.getConnection(url);
Statement stmt = null;
String username = userName_text.getText();
String password = password_text.getText();
String query = "Select username,password from users where username='" + username + "'";
try {
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
String name = rs.getString("title");
if (password.equals(rs.getString("password"))) {
this.dispose();
new timeline();
}
}} catch (SQLException e) {
throw new Error("Problem", e);
} finally {
if (stmt != null) {
stmt.close();
}}}
catch (SQLException e) {
throw new Error("Problem", e);
} finally {
try {
if (conn != null) {
conn.close();
}
} catch (SQLException ex) {
System.out.println(ex.getMessage());
this is the function the code is in, as well as the database section of the IDE
https://preview.redd.it/s9awolh8u9a81.png?width=2876&format=png&auto=webp&s=5a8d2508dc70869abac5fc5aa004ffe9b15eb271
>An absolutely massive new feature just got added to our (still alpha) PCSX2 libretro core - embedded no-interlacing database! By setting "Deinterlacing Mode" to "No-interlacing patch", it will try to apply a patch if it can find one for your game. The results are stunning!
────────
Hello, guys, to your attention
https://github.com/samokhodkin/whippet-db
It is a key-value embedded database with the very straightforward functionality. It can only store, query and list key-value pairs, but do it really good. No installation and administration, just include the jar or maven dependency to your project. And this is a plain old pure java 1.8, no native code and no Unsafe, so it's fully compatible with the oncoming Java releases.
For its size (150 kb jar with no dependencies) it's quite packed with features, including those of a "real" database, like journaling. It can operate as in-memory or file-backed off-heap storage, with a peak performance of 5-10 MOp/sec, and average 1 MOp/sec.
I wrote its core few years ago as a part of open-source research project, then it evolved as a part of a commercial project, where it was powering a custom file system, and finally I forked it as an independent opensource project.
You can start with it in 10 minutes, with this introduction and this demo project.
Whippet isn't quite finished yet, with 2 major issues to close:
-
The database size may not exceed 2GB. On reaching this limit, the inserts will gracefully throw an exception. This is due to the buffer limit in the memory mapped file design in
java.nio. I hope to fix it quite soon. The original version used a native memory implementation, so this fix wasn't needed. -
Missing is an utility to repair a corrupt database.
BTW, if someone is looking for an opensource project to contribute, you are welcome to take on these fixes.
I hope it's already worth of looking at for many of you.
So, I'm in charge of developing a product running embedded Linux, running several consumer and producer processes, with the amount of interaction between them being on the order of magnitude of 10s of <1kB messages per minute.
I originally wanted to use some actual IPC (e.g. gRPC) to have them talk to each other, however another person in the company (more experienced than myself, have done embedded in previous lives, a little bit of a my-way-is-best-way attitude) has been absolutely trashing this plan and insisting we use a single central database as a way for the processes to leave messages for each other.
This doesn't sit right with me because it doesn't feel "proper" and besides Database-as-IPC is a well known anti-pattern. That said, the main problem with it seems to be scalability, which shouldn't be much of an issue where all I'm expecting is 10s of 1kB messages per minute (mayyyybe up to a 100s).
My colleague's main reasons for wanting to go with a database like that is that it simplifies the architecture - we only need every process to interact with the database instead of separately designing interactions between each one of them.
Does the collective wisdom of Reddit Embedded Linux wizards have any thoughts on the subject? Is there anything else I should be considering before settling on a final architecture? Would looking into an actual message queue like ZeroMQ be worth it given that none on our team has worked with message queues before?
ESP-IDF provides the function of NV management. However, the function is relatively simple, and some data with a large amount of data cannot be stored. For a large data amount scenario, the query speed is also a factor to be considered.
Therefore, I open sourced an ultra-lightweight embedded database. It is small in size and fast in query speed, which is very suitable for application in IoT scenarios like ESP32
For more introduction, please check https://github.com/armink/FlashDB
I'm excited to announce my first plugin: Couchbase Lite Dart
link: https://pub.dev/packages/couchbase_lite_dart
Couchbase Lite is an embedded no sql database with support for Android(Java) and iOS(Swift).
This is an almost feature complete implementation of their C library in Dart using ffi. The goal of this library is to provide a native plugin that does not depend on platorm channels to support as many platforms as possible.
Currently I focused on Windows, but Android and iOS should work out of the box once I figure out how to build/bundle the static libraries.
While it is almost feature complete, it is not production ready yet. Testing and contributions are welcome.
Here's a demo of an app running on windows, you can find the source code in the example folder of the package. Windows Demo
Hi, does anyone know of any database drawing tools (could even be as simple google docs or notion) that can be embedded into clickup?
Hey,
Does someone know if a SQL database fully integrated in Mono exists ? By fully integrated I mean : not a simple wrapper that uses an external engine like SQLite.
Thanks !
Haskey looks good, but is not cross-platform. Is there something small and reliable available in hackage?
This is for a desktop application, so does not need an enterprise feature set.
Big news from earlier this month.
Becoming an official CCP member is an extremely competitive and arduous process, and you must take an oath of allegiance to the Party. Members must either be Chinese citizens or major investors in China. The fact that CCP members have infiltrated so many powerful worldwide organizations raises great concern that they may be spreading propaganda and/or engaged with espionage.
Infiltrated entities include AstraZenica, Pfizer, Boeing, Airbus, Rolls Royce, HSBC bank, Standard Chartered bank, New York University, and the USA and British consulates in Shanghai.
The database of 2 million CCP members has been reported on by a number of news outlets worldwide. Curiously, the New York Times makes no mention of it. Also curiously, Business Insider India covers the story, but it can't be found on the primary Business Insider page.
Daily Mail (UK) https://www.dailymail.co.uk/news/article-9046783/Leaked-files-expose-mass-infiltration-UK-firms-Chinese-Communist-Party.html
New York Post https://nypost.com/2020/12/13/us-companies-riddled-with-members-of-chinese-communist-party/
Business Insider India https://www.businessinsider.in/tech/news/a-data-leak-shows-that-over-two-million-chinese-communist-party-members-were-secretly-embedded-in-organizations-around-the-world/articleshow/79720017.cms
Since FlashDB V1.0.0 was released , soon some developers in the community ported it to ESP8266: https://armink.github.io/FlashDB/#/demo-esp8266-spi-flash
FlashDB now provides a file-based ultra-lightweight database mode. This means that as long as you use ESP-IDF and open the file system, you can also use FlashDB
For more, please see the demo base on linux: https://github.com/armink/FlashDB/tree/master/demos/linux
It's a small API that'll be used by a small business, mostly for POS (sales) services. It would mostly be used in 2 or 3 computers for 10 hours a day (office is used 10 hours a day) for 7 days, and it currently saves data to an embedded h2 database. Should I transfer to MYSQL and use a different service for it? If yes, what would be the best service?
I’m currently doing my A-level computer science project where I’m creating a social media platform I am using Intellij Idea’s feature of the embedded database and I am coding in Java, with the database in SQLite. However, I am having issues with calling and searching the database as I have only been coding in Java for a short amount of time. I have researched online but it has not been much help as everyone does it differently, and none of the methods use the embedded database feature. Does anyone have any advice on how to actually call, connect, and search my database?
This is my code where I am trying to connect and search my database which is broken
@Override
public void actionPerformed(ActionEvent ae) {
if (ae.getSource() == createButton) {
this.dispose();
new Create();
}
Connection conn = null;
try {
String url = "jdbc:sqlite:/Users/user/Desktop/A-LEVELS/COMPUTING/ProjectAppGui/Users";
conn = DriverManager.getConnection(url);
Statement stmt = null;
String username = userName_text.getText();
String password = password_text.getText();
String query = "Select username,password from users where username='" + username + "'";
try {
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
String name = rs.getString("title");
if (password.equals(rs.getString("password"))) {
this.dispose();
new timeline();
}
}} catch (SQLException e) {
throw new Error("Problem", e);
} finally {
if (stmt != null) {
stmt.close();
}}}
catch (SQLException e) {
throw new Error("Problem", e);
} finally {
try {
if (conn != null) {
conn.close();
}
} catch (SQLException ex) {
System.out.println(ex.getMessage());
Hey,
Does someone know if a SQL database fully integrated in Mono exists ? By fully integrated I mean : not a simple wrapper that uses an external engine like SQLite. I need to be able to export it wherever Godot Mono projects can run.
Thanks
