• 0

Lightweight Database Server for Java Applications? Sqlite...?

Asked by roosevelt,

 Share

Question

Mentor

roosevelt

Posted
Posted

Hi,

I am developing a Java application and want to use a database to structure my contents better. Sqlite3 was my my first choice but because of the nature of my program, it may not be the best solution. My application will be performing different operations and will be using multiple threads.

The unit tests I wrote indicates that they are trying to create multiple connections and that is causing the file-lock, so test 1 passes because it was able to successfully connect but test 2 fails because it could not write to the file.

My application is not that extensive either that I will need Mysql or something big like Oracle.

So, are there any good database server that might instantiate when I launch my application? And won't have trouble even if I make 100 connections and attempt to insert 1000s of rows at once from different threads? :p

Looking into Java DB... not sure if it's the one I need :/

Thanks :)

2 answers to this question

Recommended Posts

  • 0
Experienced

paxa

Posted
Posted

why don't you do this, get the data you need at startup. manipulate it in a Model, like the MVC software pattern. when your app closes, or you don't need the data, you can sync the data with the database in one, or various transactions.

and with something like this you can maintain sqlite.

This topic is now closed to further replies.
 Share
Go to question listing

  • Posts

    • AMD 9060 XT performance benchmarks vs Nvidia 5060 Ti, 5060, AMD 9070 XT, 7600 XT, leaks

      By Mockingbird · Posted

      The Radeon RX 9060 XT is 5% slower than the GeForce RTX 5060 Ti, but the GeForce RTX 5060 Ti is 23% more expensive, at least when comparing MSRPs.
    • Radeon RX 9060 XT 16GB performance revealed

      By Mockingbird · Posted

    • Politically funny images of the World

      By snowy owl · Posted

      I would love to see Musk's face! 🤣🤣🤣
    • UK government trial reveals Microsoft 365 Copilot's surprising impact on daily work

      By fingletmein · Posted

      I think each AI option has their ups and downs. For Copilot, I find it more personable in how it talks compared to GPT & Gemini. I also appreciate the open ended questions it often provides at the end of its responses to keep the conversation going.
    • Microsoft offers free access to AI video creation with Bing Video Creator

      By pradeepviswav · Posted

      Microsoft offers free access to AI video creation with Bing Video Creator by Pradeep Viswanathan Two years ago, Bing Image Creator became one of the first major online services that allowed users to create images from text using OpenAI’s DALL-E model. Today, Microsoft is introducing Bing Video Creator, powered by OpenAI’s Sora, allowing users to create videos with text prompts. Despite announcing Sora last year, OpenAI has not been able to expand its availability to millions of ChatGPT users due to huge AI infrastructure requirements. It is still only available to ChatGPT Pro subscription users, which costs about $200 per month. Recently, Google announced its Veo 3 video generation model, which performs significantly better than OpenAI’s Sora, to all Gemini paid subscribers, making video generation accessible to even Gemini Pro subscribers, which costs just $20 per month. Now, Microsoft is democratizing access to video generation models by making Bing Video Creator free for all Bing users. Bing Video Creator is rolling out today globally (excluding China and Russia) on the Bing Mobile App, and it will be coming soon to the Bing desktop experience within Copilot Search. Bing Video Creator users will have the ability to choose between Fast and Standard generation speeds. Each user will have 10 Fast creations; following that, users can redeem 100 Microsoft Rewards points for each Fast creation or continue with Standard creation speeds. Once you have downloaded the Bing mobile app, here’s how you can access the Video Creator feature: Open Video Creator within the Bing Mobile app by clicking on the menu in the bottom right corner and selecting “Video Creator.” Just type in a text description of the video you want to create in the prompt box. Once the prompt text is ready, just tap “Create.” Or you can also just type directly into the Bing mobile app search bar "Create a video of..." to create a video. You’ll receive a notification when your video is ready to view. If required, you can also download the video or share it via social media or email. You will also have the ability to copy a direct link to the video for easy sharing elsewhere. Microsoft will be storing the generated videos for up to 90 days in your account for easy access later. Microsoft noted that the Bing Video Creator videos are 5 seconds long and can be created only in 9:16 format for now. Microsoft will be adding the 16:9 format soon. When you are waiting for your video to be created, you can also queue up another two videos. Once one of the slots becomes available, you can add another one to the queue. When Bing Video Creator becomes available on desktop, you can visit Bing.com/create for both image and video creation needs.

  • Recent Achievements

    • Week One Done
      Nullun earned a badge
      Week One Done
    • First Post
      sultangris earned a badge
      First Post
    • Reacting Well
      sultangris earned a badge
      Reacting Well
    • First Post
      ClarkB earned a badge
      First Post
    • Week One Done
      Epaminombas earned a badge
      Week One Done

  • Popular Contributors

    1. 1
      +primortal
      150
    2. 2
      ATLien_0
      122
    3. 3
      Xenon
      121
    4. 4
      snowy owl
      99
    5. 5
      +Edouard
      95
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!