Using SQLite as BE ok? (1 Viewer)

[FuzMic]

Hi contributors
I have plan to use SQLite because it LESS many things for small projects. Any caveat or advices to drop to my new venture. Thanks brotherhood.

 

[plog]

That's a pretty broad question with very little context.

My advice is to Google around to see if SQLlite is the correct database for your application

 

[June7]

I don't understand your reason for using SQLite. What do you plan to use for frontend - Access?

 

[Uncle Gizmo]

Sounds like an interesting project!

Looks possible, see here:-

How To Connect To A SQLite Database With VBA - Learn Data Analysis

In this post, I will be sharing the steps on how you can connect to a SQLite database using VBA.

learndataanalysis.org

I'd like to know how you get on with it.

 

[FuzMic]

To clarify SQLite is only for BE while FE is msaccess as it very familiar RAD. ODBC will be used to connect to BE

 

[jdraw]

FuzMic,

Sounds like an interesting project. Can you tell us more about your rationale to use Sqlite as BE?
Is this mainly an academic exercise?

I did some googling and found this old (2013) thread.

 

[GPGeorge]

I found this rather interesting statement on the SQLLite page.

Client/server SQL database engines strive to implement a shared repository of enterprise data. They emphasize scalability, concurrency, centralization, and control. SQLite strives to provide local data storage for individual applications and devices. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity.

 

[FuzMic]

I am attracted to SQLite because it LESS many overhèads like server objects. Until I can get it really going the verdict is not out but from my reading I am hopeful to bypass other SQL servers or accdb.

 

[jdraw]

Can you tell us about your proposed application?

 

[FuzMic]

Guys more context

For years i wanted to use one of the SQL Server application as my backEnd. I was using accdb or mdb for the BE in an low volume & low users LAN environment. I was reluctant to move because of server overheads. Then watching the android up surge i found a popular BE provider SQLite. I like it because there is no server requirement and things looks robust.
When I chat with SQLIte experts they warn me that it is not intended for high users number environment which is the order of 200. But since my projects are tiny this is now not an issue at all.

Meanwhile I have to consider one important issue, how to connect msaccess to it. I was thinking of ODBC to provide links to the tables in the SQLite. Some expert shared that he use system.data.sqlite.dll library to access SQLite in .Net; but then how how to do this with msaccess.

 

[Pat Hartman]

If there is no server where the shared data is stored, I doubt this will work for you. EXACTLY WHERE is the data stored?

Microsoft's SQL Server Express is free. I suppose you could run it on one node of a peer-to-peer LAN but that node would always need to be "on" or the other users won't be able to use the app. I can run SQL Server on my home network and other nodes can "see" the database on my desktop.

When you are developing multi-user software, there is a minimum technology level.

Don't let that discourage you. If you have the time, then give it a shot.

 

[June7]

Well, did you try method from link in post # 4?