SQL Server Express LocalDB Embedded?

• meliodes

  SSC Veteran

  Points: 217

  More actions

  May 4, 2022 at 9:04 am

  #4026471

  I am going to write a single user personal application and I’m trying to decide which database system to choose. SQLite and Access (Jet) are contenders because they are embedded and do not require a server service to be running and I’m wondering if SQL Server Express LocalDB can be configured similarly? https://omegle.onl/

  • This topic was modified 3 years ago by meliodes.

• Ken McKelvey

  SSCoach

  Points: 18907

  More actions

  May 4, 2022 at 10:03 am

  #4026508

  https://dev.to/vicobiscotti/finally-switching-from-microsoft-localdb-to-sqlite-29mo

   

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  May 4, 2022 at 10:39 am

  #4026520

  The full-fledged Express Edition runs as a service. But, localdb runs in user-space so it could serve for a single-user application. Although, I mainly think of localdb as an aide for development and testing, but that may be just my perception.

  As for the choice, I'm an SQL Server guy, so I might pick localdb because I'm more used to that. But I believe that Windows comes with SQLite, which would be a strong argument for SQLite.

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]