New ask Hacker News story: Open File Format for Spreadsheets
Open File Format for Spreadsheets
2 by vxGxKrGU | 1 comments on Hacker News.
I have this idea, guys I wanted to know your opinion: 1. My idea would be an open file format called csvsheets. csvsheets file is csv format with spreadsheet function. My idea would be how people have a database in a spreadsheet but with a freer format without much complexity. 2. This would be nice if you don't want to rely on software company to open plain text files like Microsoft Office Excel etc. I thought about it because I think the xml format in my view compared to csv is bad. xslx is xml based is proprietary. There are of course open file formats, that's my idea of open file format. 3. I was thinking of using the sqlite format, but it's something that hasn't been implemented yet. ``` =CONCATENAR(A1:H7,A1:H7,1), =PISO(A1:H7,A1:H7,1), =BINOMDIST(A1:H7,A1:H7,1) =CHIDIST(A1:H7,A1:H7,1), =CHIINV(A1:H7,A1:H7,1), =CHITEST(A1:H7,A1:H7,1) =CONFIANÇA(A1:H7,A1:H7,1), =FTEST(A1:H7,A1:H7,1), =LOGINV(A1:H7,A1:H7,1) =LOGNORMDIST(A1:H7,A1:H7,1), = DIST.NORM(A1:H7,A1:H7,1), =NORMINV(A1:H7,A1:H7,1) = DIST.NORM(A1:H7,A1:H7,1), =NORMSINV(A1:H7,A1:H7,1), =PERCENTIL(A1:H7,A1:H7,1) ... ``` command description: These are some functions, it's just an illustration of csvhseets #### Ideas 1. I don't want to depend on a software company to open simple databases like csv. Csvsheets is an interesting format and not yet implemented 2. My idea would be implementation, but I want to know everyone's opinion here. My idea is with csvsheets is that i get business rules from spreadsheet files and easily if i need to replace with a database like postgres, mongodb, sql server, mariadb i can 3. Csvsheets makes it easy to migrate from robust spreadsheets, that's the idea 4. There are trades that a database of many data is made by electronic spreadsheet. My idea here is to give people freedom 5. This format reserved in gpl 2 license which is the same as linux. I believe csvsheets format can help people who don't have the money for a robust database. There is no size for csvsheets files. The choice of csv format is that many databases are already able to read this file format 6. In theory you can get a very fast system with csvsheets, just know csv and excel and create the rules in csv with excel formulas. 7. The cool thing about this is the possibility of migrating the data to a larger database. The coolest is a csv file format with excel formula support. The GUI part would be done with html, css, js. There are systems like firefox os that implement this. Talk about csvsheets which is something very interesting, but I forgot to talk about how to create a csvsheets interface. 8. Thought to implement csvsheets in rust, there is a browser made in rust called servo, the servo supports html, js, css. 9. With the servo implementation I wanted a visual structure for the csvsheets. In summary, csvsheets is a csv format with excel formula support, a visual interface made from html, css, js. 10. The manipulation and data structure part is the same as sql but applied to a csvsheets. The graphics part is not done by the graphical user interface, it is done by the command line. 11. My idea is this: 1. Format name: CSV Spreadsheets, extension: .csvsht 2. Data Manipulation Language (DML), Data Definition Language (DDL), Data Control Language (DCL), Transactional Control Language (TCL) is the same as Transact-SQL for csvsht. But supports: SchemeQL, CLSQL, ScalaQL ... 3. Spreadsheet Extended Data Definition Language for Business Rules: Markdeep, Svgbob, asciigrid, Archetype, Textik, ASCIIFlow, textik, fsymbols ... this allows you to create business rules, open charts in csvsheets 4. Every csvsht file can generate an api in several programming languages: python, lisp, c, c++ ...
2 by vxGxKrGU | 1 comments on Hacker News.
I have this idea, guys I wanted to know your opinion: 1. My idea would be an open file format called csvsheets. csvsheets file is csv format with spreadsheet function. My idea would be how people have a database in a spreadsheet but with a freer format without much complexity. 2. This would be nice if you don't want to rely on software company to open plain text files like Microsoft Office Excel etc. I thought about it because I think the xml format in my view compared to csv is bad. xslx is xml based is proprietary. There are of course open file formats, that's my idea of open file format. 3. I was thinking of using the sqlite format, but it's something that hasn't been implemented yet. ``` =CONCATENAR(A1:H7,A1:H7,1), =PISO(A1:H7,A1:H7,1), =BINOMDIST(A1:H7,A1:H7,1) =CHIDIST(A1:H7,A1:H7,1), =CHIINV(A1:H7,A1:H7,1), =CHITEST(A1:H7,A1:H7,1) =CONFIANÇA(A1:H7,A1:H7,1), =FTEST(A1:H7,A1:H7,1), =LOGINV(A1:H7,A1:H7,1) =LOGNORMDIST(A1:H7,A1:H7,1), = DIST.NORM(A1:H7,A1:H7,1), =NORMINV(A1:H7,A1:H7,1) = DIST.NORM(A1:H7,A1:H7,1), =NORMSINV(A1:H7,A1:H7,1), =PERCENTIL(A1:H7,A1:H7,1) ... ``` command description: These are some functions, it's just an illustration of csvhseets #### Ideas 1. I don't want to depend on a software company to open simple databases like csv. Csvsheets is an interesting format and not yet implemented 2. My idea would be implementation, but I want to know everyone's opinion here. My idea is with csvsheets is that i get business rules from spreadsheet files and easily if i need to replace with a database like postgres, mongodb, sql server, mariadb i can 3. Csvsheets makes it easy to migrate from robust spreadsheets, that's the idea 4. There are trades that a database of many data is made by electronic spreadsheet. My idea here is to give people freedom 5. This format reserved in gpl 2 license which is the same as linux. I believe csvsheets format can help people who don't have the money for a robust database. There is no size for csvsheets files. The choice of csv format is that many databases are already able to read this file format 6. In theory you can get a very fast system with csvsheets, just know csv and excel and create the rules in csv with excel formulas. 7. The cool thing about this is the possibility of migrating the data to a larger database. The coolest is a csv file format with excel formula support. The GUI part would be done with html, css, js. There are systems like firefox os that implement this. Talk about csvsheets which is something very interesting, but I forgot to talk about how to create a csvsheets interface. 8. Thought to implement csvsheets in rust, there is a browser made in rust called servo, the servo supports html, js, css. 9. With the servo implementation I wanted a visual structure for the csvsheets. In summary, csvsheets is a csv format with excel formula support, a visual interface made from html, css, js. 10. The manipulation and data structure part is the same as sql but applied to a csvsheets. The graphics part is not done by the graphical user interface, it is done by the command line. 11. My idea is this: 1. Format name: CSV Spreadsheets, extension: .csvsht 2. Data Manipulation Language (DML), Data Definition Language (DDL), Data Control Language (DCL), Transactional Control Language (TCL) is the same as Transact-SQL for csvsht. But supports: SchemeQL, CLSQL, ScalaQL ... 3. Spreadsheet Extended Data Definition Language for Business Rules: Markdeep, Svgbob, asciigrid, Archetype, Textik, ASCIIFlow, textik, fsymbols ... this allows you to create business rules, open charts in csvsheets 4. Every csvsht file can generate an api in several programming languages: python, lisp, c, c++ ...
Comments
Post a Comment