Recent

Author Topic: NoSQL created by Free Pascal  (Read 7194 times)

Almir.Bispo

  • Jr. Member
  • **
  • Posts: 91
  • CSV Comp DB is the Best NoSQL
    • CSV Comp DB (NoSQL)
NoSQL created by Free Pascal
« on: July 01, 2017, 12:45:11 am »
CSV Comp DB is a NoSQL created entirely with Lazarus. Unlike other Nosql, it uses csv files as tables and has a specific language called CQL (Comma Query Language) that enables data manipulation and (MVC). To facilitate internalization ILDE-Pascal allows interactions with any program created with Free Pascal (Lazarus, Delphi) in client / server or tcp architectures.
You can download and try by yourself using ILDE-Pascal
http://adltecnologia.blogspot.com.br
CSV Comp DB Developer {Pascal Lover}

Leledumbo

  • Hero Member
  • *****
  • Posts: 8747
  • Programming + Glam Metal + Tae Kwon Do = Me
Re: NoSQL created by Free Pascal
« Reply #1 on: July 01, 2017, 01:21:26 am »
So it's a NoSQL but relational? Kinda weird concept since NoSQL was made to kick relations out of the database...

taazz

  • Hero Member
  • *****
  • Posts: 5368
Re: NoSQL created by Free Pascal
« Reply #2 on: July 01, 2017, 01:47:09 am »
So it's a NoSQL but relational? Kinda weird concept since NoSQL was made to kick relations out of the database...
Isn't NoSQL the modern terminology for an hierarchical name/value database? something along the lines of XML with transactions? Genuine curiosity I have heard the term repeatedly but I always thought that it was a step backwards to an pre SQL era where databases where as easy to use as doing brain surgery on your self.
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64

Leledumbo

  • Hero Member
  • *****
  • Posts: 8747
  • Programming + Glam Metal + Tae Kwon Do = Me
Re: NoSQL created by Free Pascal
« Reply #3 on: July 01, 2017, 04:05:41 am »
Isn't NoSQL the modern terminology for an hierarchical name/value database?
Not always, key-value store is just one of its implementations, despite indeed it seems to be the most well known one (a bit behind is the document store, where more sophisticated queries can be done easier, e.g. generating reports is a one query as opposed to one loop of queries).

taazz

  • Hero Member
  • *****
  • Posts: 5368
Re: NoSQL created by Free Pascal
« Reply #4 on: July 01, 2017, 06:43:13 am »
Isn't NoSQL the modern terminology for an hierarchical name/value database?
Not always, key-value store is just one of its implementations, despite indeed it seems to be the most well known one (a bit behind is the document store, where more sophisticated queries can be done easier, e.g. generating reports is a one query as opposed to one loop of queries).
lol.
Quote
Document-oriented databases are inherently a subclass of the key-value store, another NoSQL database concept
from https://en.wikipedia.org/wiki/Document-oriented_database.
So noSQL is a simple file system with transactions.
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64

Almir.Bispo

  • Jr. Member
  • **
  • Posts: 91
  • CSV Comp DB is the Best NoSQL
    • CSV Comp DB (NoSQL)
Re: NoSQL created by Free Pascal
« Reply #5 on: August 16, 2017, 09:35:40 pm »
I present a practical example of an application created using Lazarus by accessing (and manipulating) a remote database (localhost) using Synapse and CSV Comp DB (CGI).
I want to keep this unique post referring to NoSql CSV Comp DB and constantly announce some examples of applications (with source code).
The tutorial is in Portuguese but has steps written in English. This can be watched in the video of the link (divided in 2 parts).

Part 1 https://www.youtube.com/watch?v=2XytLSkgyQw
Part2 https://www.youtube.com/watch?v=QmI3kIdPVK4
The source is on my blog http://adltecnologia.blogspot.com.br
CSV Comp DB Developer {Pascal Lover}

Almir.Bispo

  • Jr. Member
  • **
  • Posts: 91
  • CSV Comp DB is the Best NoSQL
    • CSV Comp DB (NoSQL)
Re: NoSQL created by Free Pascal
« Reply #6 on: August 21, 2017, 10:40:15 pm »
Hello!
The driver to Database manager was aupdated today.All old bugs had been solved.
It works so:
Code: Pascal  [Select][+][-]
  1. program project1;
  2.  
  3. {$mode objfpc}{$H+}
  4.  
  5. uses
  6.   {$IFDEF UNIX}{$IFDEF UseCThreads}
  7.   cthreads,
  8.   {$ENDIF}{$ENDIF}
  9.   Classes ,
  10.   { you can add units after this }
  11. crt, strutils, sysutils  ;
  12.  
  13. {$R *.res}
  14. //call
  15. {$i cql_to_pascal.txt}
  16.  
  17. var cmd,DB,table,fields,data:string;
  18. begin
  19.   writeln('Starting Database Manager Simple Exemple');
  20.   repeat
  21.   textcolor(10);
  22.   writeln('Type Database name (Full path):');
  23.   textcolor(12);
  24.   readln(DB);
  25.   textcolor(10);
  26.   writeln('Type Table name:');
  27.   textcolor(12);
  28.   readln(table);
  29.   textcolor(10);
  30.   writeln('Type Fields (semicolon delimited):');
  31.   textcolor(12);
  32.   readln(fields);
  33.   textcolor(10);
  34.   writeln('Type data (semicolon delimited):');
  35.   textcolor(12);
  36.   readln(data);
  37. //concatenation the CQL commando to cmd string
  38. //create a table
  39. cmd:= create_table(DB,table);
  40. //create fields on table
  41. cmd:= cmd + create_fields(DB,table,'('+fields+')');
  42. //add data to table
  43. cmd:= cmd + add_data(DB,table,'('+data+')');
  44.  
  45. //execute all
  46. CSV_COMP_DB_execute( cmd ) ;
  47.  
  48. writeln('Do you want to do it again? y/n');
  49. readln(cmd);
  50.   until (cmd='n');
  51. end.
  52.  
  53.  
  54.  
Work in console or GUI mode.

You can download on  site http://adltecnologia.blogspot.com.br
CSV Comp DB Developer {Pascal Lover}

Almir.Bispo

  • Jr. Member
  • **
  • Posts: 91
  • CSV Comp DB is the Best NoSQL
    • CSV Comp DB (NoSQL)
Re: NoSQL created by Free Pascal
« Reply #7 on: September 01, 2017, 07:55:04 pm »
Hello1.Now there are Linux Versions Updated.
The CGI version on Linux is in experience state.The Windows version works fine.
Download on blog: http://adltecnologia.blogspot.com.br
CSV Comp DB Developer {Pascal Lover}

 

TinyPortal © 2005-2018