Recent

Author Topic: Find an open source small network database  (Read 12382 times)

lazpas

  • Jr. Member
  • **
  • Posts: 74
Find an open source small network database
« on: August 04, 2021, 10:18:39 am »
Where is the open source small network database? I want to learn the principle.

Thanks.

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: Find an open source small network database
« Reply #1 on: August 04, 2021, 11:06:36 am »
I don't understand your question.

Firebird and SQLite is an open source small network database.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

valdir.marcos

  • Hero Member
  • *****
  • Posts: 1106
Re: Find an open source small network database
« Reply #2 on: August 04, 2021, 11:10:29 am »
Where is the open source small network database? I want to learn the principle.
Thanks.
Firebird would be your best option:
http://firebirdsql.org/en/firebird-rdbms/

lazpas

  • Jr. Member
  • **
  • Posts: 74
Re: Find an open source small network database
« Reply #3 on: August 04, 2021, 11:29:34 am »
I don't understand your question.

Firebird and SQLite is an open source small network database.
Thanks.

sqlite is not a network database. Firebird is very large. I am a newbie. :)

marcov

  • Administrator
  • Hero Member
  • *
  • Posts: 11383
  • FPC developer.
Re: Find an open source small network database
« Reply #4 on: August 04, 2021, 11:33:29 am »
sqlite is not a network database. Firebird is very large. I am a newbie. :)

Please qualify what large is acceptable and what not. This is all too vague. Most open source database systems run fine on an original raspberry pi.

lazpas

  • Jr. Member
  • **
  • Posts: 74
Re: Find an open source small network database
« Reply #5 on: August 04, 2021, 11:37:28 am »
Where is the open source small network database? I want to learn the principle.
Thanks.
Firebird would be your best option:
http://firebirdsql.org/en/firebird-rdbms/

Thank you.

Firebird is very good.But it is large,and I don't know how to C++.I am a newbie.


lazpas

  • Jr. Member
  • **
  • Posts: 74
Re: Find an open source small network database
« Reply #6 on: August 04, 2021, 11:42:27 am »
Is there a pascal language?

lazpas

  • Jr. Member
  • **
  • Posts: 74
Re: Find an open source small network database
« Reply #7 on: August 04, 2021, 11:50:37 am »
sqlite is not a network database. Firebird is very large. I am a newbie. :)

Please qualify what large is acceptable and what not. This is all too vague. Most open source database systems run fine on an original raspberry pi.

Thanks for reply.

I think, as little code as possible, a framework, including network, file io, thread, and possibly functions. basic skills.

valdir.marcos

  • Hero Member
  • *****
  • Posts: 1106
Re: Find an open source small network database
« Reply #8 on: August 04, 2021, 07:46:42 pm »
I don't understand your question.

Firebird and SQLite is an open source small network database.
Thanks.

sqlite is not a network database. Firebird is very large. I am a newbie. :)


Where is the open source small network database? I want to learn the principle.
Thanks.
Firebird would be your best option:
http://firebirdsql.org/en/firebird-rdbms/
Thank you.

Firebird is very good.But it is large,and I don't know how to C++.I am a newbie.


Is there a pascal language?


sqlite is not a network database. Firebird is very large. I am a newbie. :)
Please qualify what large is acceptable and what not. This is all too vague. Most open source database systems run fine on an original raspberry pi.
Thanks for reply.

I think, as little code as possible, a framework, including network, file io, thread, and possibly functions. basic skills.
Lighter than Firebird, only if you would use an old xBase solution, such as DBase or Paradox.
And they have Pascal source code:
https://wiki.freepascal.org/Lazarus_Tdbf_Tutorial
https://wiki.freepascal.org/TParadoxDataSet

lazpas

  • Jr. Member
  • **
  • Posts: 74
Re: Find an open source small network database
« Reply #9 on: August 05, 2021, 01:30:15 am »
Lighter than Firebird, only if you would use an old xBase solution, such as DBase or Paradox.
And they have Pascal source code:
https://wiki.freepascal.org/Lazarus_Tdbf_Tutorial
https://wiki.freepascal.org/TParadoxDataSet

Thanks for help. :)

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: Find an open source small network database
« Reply #10 on: August 06, 2021, 11:31:17 am »


Thank you.

Firebird is very good.But it is large,and I don't know how to C++.I am a newbie.
[/quote]

You're very vague. You don't need C++ to use Firebird. Also Firebird can also use embedded. That's not large.
But yes, you can build a large database with it.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

lazpas

  • Jr. Member
  • **
  • Posts: 74
Re: Find an open source small network database
« Reply #11 on: August 08, 2021, 08:24:51 am »


Thank you.

Firebird is very good.But it is large,and I don't know how to C++.I am a newbie.

You're very vague. You don't need C++ to use Firebird. Also Firebird can also use embedded. That's not large.
But yes, you can build a large database with it.
[/quote]
Hi,mangakissa

My English is bad,sorry.I use online translation.

I mean to learn client-server database principles.How to make a client-server database.


lazpas

  • Jr. Member
  • **
  • Posts: 74

MarkMLl

  • Hero Member
  • *****
  • Posts: 6676
Re: Find an open source small network database
« Reply #13 on: August 08, 2021, 11:18:47 am »
I have found these
https://github.com/ggaughan/ThinkSQL

https://sourceforge.net/projects/tpflashfiler/

Have you actually read the description that goes with ThinkSQL?

Quote
The source code is linear per se, but while writing it, it was an organic thing, generating great interwoven trees in the computer memory and in my head that were many-layered and that were modified and traversed, and impacted on a dynamic multi-versioned data store alongside many other threads, causing and needing deep psychological flow. The code comments are released as-is, and are often streams-of-consciousness.

A number of other people have given you some good suggestions and to those I'd add that you might find it worthwhile looking for an early version of PostgreSQL, i.e. v6 or older, which basically started off as a teaching/research exercise so at least in those days was well documented.

Look, I'm sorry to be brutal but software is /complex/, and the more man-years have gone into a project the more complex it's likely to be. Alternatively, if a project was left on a hillside at birth it's likely to be valueless, and a waste of time in terms of both utility and didactic potential.

If you think that, as somebody with admittedly-limited experience, your chances of getting to grips with a project are dominated by your familiarity with the language it's written in then you're fooling nobody but yourself: these days you /need/ at least limited familiarity with C/C++ (and, regrettably, with Python and Javascript) even if you have no intention of writing anything in them.

MarkMLl
MT+86 & Turbo Pascal v1 on CCP/M-86, multitasking with LAN & graphics in 128Kb.
Pet hate: people who boast about the size and sophistication of their computer.
GitHub repositories: https://github.com/MarkMLl?tab=repositories

PierceNg

  • Sr. Member
  • ****
  • Posts: 369
    • SamadhiWeb
Re: Find an open source small network database
« Reply #14 on: August 08, 2021, 01:12:30 pm »
I mean to learn client-server database principles.How to make a client-server database.

Learn the various bits. For a networked SQL database, some key pieces:
  • how to organize data on disk using B-trees etc
  • how to parse SQL
  • how to execute the parsed SQL to work with the stored data
  • backup and restore
  • authentication and authorization
  • network programming
  • data encryption over the wire
  • data encryption at rest
  • SDK for database client programming

Anything important missing from my list I'm sure others will add.

 

TinyPortal © 2005-2018