thaianhsoft

thaianhsoft

Which modules to implement RDBMS in Elixir/Erlang effectively?

I have been self-studying computer science and have a passion for elixir. I want to implement a simple relational database from a few assignments.
But since then, a lot of questions which I haven’t solved. I have core layers are buffer manager layer and it manages disk manager layer

  1. Buffer Manager fetches N pages in a unit of bytes to perform actions faster in memory from the disk manager. If I assume that each page is one struct with one list of multiple records
    How do fetch these structs into memory do something and then flush them from memory to disk such as external merge sorting?
    What’s the module name similar to the Java Serialization interface or something like that?

I know this thing isn’t suitable in elixir form. But I really have a passion for Elixir/Erlang and hope to bring elixir in my background all time. I want to make things challenging myself in Elixir/Erlang to use proficient or anyone interest in this thing like me can see them.

Thanks, anyone reading

Most Liked

lucaong

lucaong

If you are interested in how a database engine can be implemented entirely in Elixir, you can give a look to CubDB (it’s a bit of shameless self promotion, as I am the author :slight_smile:). It is not a relational database, but rather an embedded datastore supporting key/value access, selection of ranges, and atomic transactions, but such a storage engine is normally the core on top of which relational features are implemented.

mpope

mpope

For serialization, you could use the built in erlang:term_to_binary/1 on any term, and use zlib — OTP 29.0.2 (erts 17.0.2) for compression, or an external zstd library.

thaianhsoft

thaianhsoft

oh, your internal source has implement of B tree, which I have searching for in functional programming. Thanks for this thing

Where Next?

Popular in Questions Top

_russellb
I want to try my hand at web scraping. What tools/libraries do I need to use. I’m hoping to turn this into something professional so don’...
New
lastday4you
I wanted to check elixir version in phoenix because i found that my elixir is 1.5 but when i use Enum.chunk_by it said the function is un...
New
greenz1
I have a phoenix application from which a user can download multiple(5-6) files of size 1MB. I couldn’t find anything related to sending ...
New
ycv005
I have followed this StackOverflow post to install the specific version of Erlang. And When I am running mix ecto.setup then getting fol...
New
SoCreat
i’m a new one to elixir which editor can i use vs code? or atom? Thanks! :smiley:
New
nobody
Hi! In PHP: $_SERVER[‘SERVER_ADDR’] - in Elixir? Searched the docs for ip address and the web, no good results. Thanks!
New
jason.o
In the code below, if the create action is not set to accept “extra_key” as an input, it errors out with a message shown above. Is there ...
New
script
If I have a string “1000 cfu/ml” . I want to remove the characters and / and space . So the string is like this "1000" What is the ...
New
hariharasudhan94
Lets say I have map like this fetching from my database %{"_id" => #BSON.ObjectId<58eb1a7a9ad169198c3dXXXX>, "email" => ...
New
earth10
Hi, I’m just starting to build a side-project with Elixir and Phoenix and doing some basic test with Elixir alone. What strikes me is th...
New

Other popular topics Top

danschultzer
None of the current solutions worked well for me, so I went ahead and built a user management system from scratch. This project took far...
548 29703 241
New
electic
Hi, I am new to Elixir. I am trying to use the DateTime component to insert a date into MySQL however the there seems to be no way to fo...
New
greenz1
I have a phoenix application from which a user can download multiple(5-6) files of size 1MB. I couldn’t find anything related to sending ...
New
johnnyicon
Hi all, I’ve just started learning Elixir and Phoenix Framework, so please pardon my n00bness at this stage. I’m trying to use Postgres...
New
stefanluptak
Hello everybody, usually, I use a 29" ultra-wide monitor for VSCode which can easily accomodate explorer (files panel) + file with code ...
New
boundedvariable
I am going through the kafka architecture. All the features what the kafka is providing are already in Erlang. I would like hear your opi...
New
nsuchy
Hi. I’ve noticed that Windows Powershell has it’s own IEX command and you cannot access Elixir’s IEX due to the conflict. This isn’t a cr...
New
joaquinalcerro
Hi there, I am working with Ecto-Postgresql and I need to call all of the records from a specific table but the table has 40,000 records...
New
Qqwy
Update: How to use the Blogs & Podcasts section You can post links to your blog posts or podcasts either in one of the Official Blog...
3271 127536 1222
New
lanycrost
Hi everyone! I need implement if…else if…else condition from my elixir code, and anymore of this control flow structures not work proper...
New

We're in Beta

About us Mission Statement