6

Lightweight SQL Server for Linux / Windows?

 2 years ago
source link: https://www.codesd.com/item/lightweight-sql-server-for-linux-windows.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

Lightweight SQL Server for Linux / Windows?

advertisements

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.

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.)

Do you know of an application that fits those requirements?


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

Related Articles

Using SQL Server for WSS 3.0 instead of the Windows Internal Database

There are actually two related questions: is it possible or advisable to use a full blown stand-alone SQL server for SharePoint Services WSS3.0 instead of the supplied windows internal database it comes with? The client I am working for is asking to

Accessing SQL Server from the Windows Service

I am trying to connect SQL Server from a Windows service. Now my Windows service is installed in different system. Now if I want to connect to my SQL Server, how can I connect? I am able to connect if I add the respective system userid in the SQL Ser

I can not install SQL Server 2012 on Windows 8

When I try to install SQL Server 2012 on Windows 8, I have a problem. Windows installer error message: An error occurred during the installation of assembly 'microsoft.vc80.atl,version="8.0.50727.6229",publickeytoken="1fc8b3b9a1e18e3b"

Exception when connecting to SQL Server 2008 from Windows Mobile 6.0

I would like to connect to SQL Server from windows mobile application. I tried to do that but it raises a SQL exception when the code tries to open the connection. I googled for this issue and I found article make some configuration changes at SQL Se

NTEXT with more than 4000 characters in SQL Server CE in Windows Phone

NTEXT with more than 4000 characters in SQL Server CE in windows phone I have a database in my windows phone app with a ntext field in one of the tables, I'm trying to write some content to this field, but I get an InvalidOperationException with the

Installing SQL Server 2005 on Windows 8

This question already has an answer here: How to install SQL Server 2005 Express in Windows 8 6 answers How to install SQL Server 2005 on Windows 8 64 bit?Perform these steps:- Extract sqlncli.msi / sqlncli_x64.msi from SP3 or SP4. I did it from SP4

Securing SQL Server for the Internet

I hope this question is not too broad. I am still doing research, but I was hoping to get opinions from some experts. We are a software provider and our flagship software is accessed through a portal - our SQL servers (active-active-passive cluster)

How to run and update a symbol server for Microsoft Windows on a closed network?

Background When working on a closed network (i.e. no internet connection), Microsoft's public symbol server isn't available during my debugging sessions. I'm most interested in the debug symbols for the Windows system libraries and the C-runtime libr

Anyone who successfully uses Visual Studio / IIS / SQL Server on a Windows 7 VM host on Linux for work?

I'm getting sick of various annoyances about Windows 7 like permissions and crap like that, but I need to run it for development. Any one run Windows 7 VM with development environment for .NET and a local SQL DB (as well as IIS) on top of an Ubuntu h

PowerShell searches for remote SQL Server with different Windows skills

I am trying to query a SQL Server using a a script block and passing in a different set of windows credentials. The script works if i run it on the same machine as the SQL Server but fails when i try and run it remotely. I know i can access the SQL s

Alternative to SQL Server for a Simple Web Application

I have a simple app written using SQL Server, Entity Framework, C# and WCF. When I wanted to share this app with my friends, I realised they didn't use SQL Server on their machine. I could go for SQL Server Express edition, as the usage of my app is

Unable to connect to ms sql server 2005 in Windows authentication mode using jdbc

I am trying to connect to msq sql server 2005 using jdbc.Sql server 2005 is installed in local system and I am trying in the following way.But it fails if i write the ip address of the local system instead of localhost.What would be reason. import ja

What are the ways to access Microsoft SQL Server from Linux?

We have a Windows machine running SQL Server 2005, and we need to be able to run some database queries on it from a Linux box. What are some of the recommended ways of doing this? Ideally, we would want a command-line utility similar to sqlcmd on Win

Why is access to the database (SQL Server) slower on Windows 7?

We use SQL Server 2000 to store results from our test equipment. We have installed our test software on Windows XP machines and do not have any problems with the time it takes to query from and write to the database. When we recently installed a Wind

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK