/prog/ - What are some alternatives to a database?

Name: Anonymous 2012-12-19 19:03

I want to store data and read/modify it on my Web server using Perl. I don't need something big and scary like SQL. Are there any modules or even just standard syntax for plaintext files to do this?

Name: Anonymous 2012-12-19 19:07

XML

Name: Anonymous 2012-12-19 19:07

>>2
Fucking epic.

Name: Anonymous 2012-12-19 19:10

http://blosxom.sourceforge.net/

I have no idea why most ``content management systems'' aren't written like this. Huge MediaWiki and WordPress sites, I can understand, but you don't need MySQL for your personal web site that gets fifty hits a month.
Flat files and the existing file system work fine for HTML, they work fine for most dynamic sites too.

Name: Anonymous 2012-12-19 19:20

DBIx::Class + DBD::SQLite or DBD::DBM

There is DBD::CSV if you really want plain text, but please don't.

Name: Anonymous 2012-12-19 19:21

>>4
Concurred. And make the scripts_w/cron|daemons that update your flat HTML w/ tags to make ,,Dynamic-ish``. This is old shit, even for harmful perl.

However, when you need to archive shit, and secure it, dbs like these are awesome:

Berkeley DB: oracle.com/us/products/database/berkeley-db/overview/index.html
SQLite: sqlite.org
NoSQL: strozzi.it/cgi-bin/CSA/tw7/I/en_US/nosql/Home%20Page

Name: Anonymous 2012-12-19 19:40

If SQL is ``big and scary'' to you just admit you're a worthless code monkey who doesn't understand relational algebra enough to design elegant schemas and queries. SQLite is incredibly lightweight, efficient and powerful.

Flat files? Are you fucking serious? Go back to cat-v dumb ass.

Name: Anonymous 2012-12-19 22:38

>>7
relational algebra enough to design elegant schemas and queries.
That was ENTERPRISE QUALITY!

Name: Anonymous 2012-12-20 0:15

>>8
Relational algebra is not a buzzword, it's a branch of logic. A flat file database requires you to traverse your table and write schema specific code that changes with your database design. It's the same brute force, unscientific and ultimately destructive code monkey approach to parsing XML in Java.

I guess you prefer bubble sort to quick sort because optimization and elegance is too ENTERPRISE for you.

Name: Anonymous 2012-12-20 0:26

SQLite is excellent, and is exactly what you're looking for.

``The AWK Programming Language'' has examples of building flat-file databases, but why would you bother when SQLite Just Works and will be far more performant?

Name: Anonymous 2012-12-20 2:05

Databases are slow as shit because half the time you don't need the extra ~~features~~ bloat.

How the fuck do you think databases are implemented? It's all files in the end. Cut out the middleman.

Name: Anonymous 2012-12-20 3:13

Flat files is recommended if you want hilarious VIP quality injections down the road.

Name: Anonymous 2012-12-20 3:27

>>11

7/10 I'm responding seriously:

Implying your shitty homebrewed linear search on a flat file will outperform a database system written by experts and optimised over years.

Especially something like SQLite.

Name: Anonymous 2012-12-20 4:04

>>13
More like, written by overworked code monkies, patched together when ever needed. Or in the case of open sauce, written by random clowns.
Why do you feel databases are so special, hard to grasp basic I/O and search trees?

Name: Anonymous 2012-12-20 4:15

>>14
implying you're not a random clown
You'll avoid having to write and troubleshoot a parser, your data will be more easily accessible and cross-platform, and your updates will be transactional.

Name: Anonymous 2012-12-20 4:26

>>15
Why would you want to update a value (that is destroying previous data)? That's a database trying to be the monkey, while it only should record what the monkey does. Infact I wouldn't even call it a database if it is designed to destroy data.

Name: Anonymous 2012-12-20 4:39

>>15
Why do you need a parser, for SQL? Do you need SQL? Why?

What's wrong with an imperative language and exposing the structures needed to get relevant data on the client side. You know, that might even make it possible to store the most fundamental data structure, the graph. Do you know what that is? What is a database that can not efficiently store and traverse the most fundamental data structure?

Name: Anonymous 2012-12-20 4:44

Octopress
https://github.com/shriikant/octapress

Name: Anonymous 2012-12-20 4:45

>>17

An SQL relational database is not appropriate for every situation.

But SQLite is highly appropriate for the OP's needs.

Name: Anonymous 2012-12-20 4:57

Wikipedia article on ``Critisism of science'' only links to ``Reductionism'' and ``Feminism''. Of course science is criticized by feminists as it is a male-dominated field that consistently fails to prove any female gender superiority.

Name: Le shiggy diggy quoter 2012-12-20 5:14

>>18
>"octa"press

Name: Anonymous 2012-12-20 5:22

>>17
The parser is for the stored data. Use the right tool for the job. For many many jobs, SQLite is the right tool. Use graphs when needed and use SQLite when needed.

Name: angry web dev 2012-12-20 6:01

>>18
Rooby roo!

>>1-18
I am going to end this. For publishing, Flat files. One simple transaction is done by the user and the server. For data management, *nix File System. SQL is fine too, but a daemon must publish from the DB the Data as flat files on a *nix FS for the publishing server.

Simple as a factory. Now the Daemon, could have AI, and make the publishing easier when a new Design is required.

Keeps everything compartmentalized and atomic.

Should have stay in gophersphere

Name: Anonymous 2012-12-20 9:01

SQL is a good choice is disaster recovery and latency don't matter to you
Riak is a good choice if latency doesn't matter to you
If you want something with disaster recovery, par data and low latency, you simply have to roll your own. There is no other way.

Name: Anonymous 2012-12-20 10:26

XML is the hipster's S-expressions

Name: Anonymous 2012-12-20 14:19

JSON is the hipster's XML

Name: Anonymous 2012-12-20 15:21

Why do you need a parser, for SQL? Do you need SQL? Why?
This is a sound argument, /prog/ must take the iniative to create BBQL, based on Shitpost Calculus.

______________________________________________________________________

BBQL: BarbeQuery Language
Working Draft
______________________________________________________________________BBQL is a language intended to interface to a document-based database, which sits on top of the shiichan engine. Language example: [insert] shitpost document here [turtles]99[/turtles] [/insert] [select] [where]post.turtles > 20[/where] [where-not]post ILIKE /%sage%/[/where-not] [/select] A shitpost document may contain structured ISO BBcode, broken BBcode shows up as plaintext.

Name: Anonymous 2012-12-20 15:40

>>24
SQL is a good choice is disaster recovery and latency don't matter to you
and scaling
Riak is a good choice if latency doesn't matter to you
umena latency does matter to you, so does disaster tolerance.
anyway, i do not recommend riak anyone, because it's not for pussies but for CS academics, if one cares about consistency just a little bit.

Name: Anonymous 2012-12-20 15:54

An alternative to a database is implementing half-arsed text based serialization system which is unconsistent, non-atomic and downright scary.

Name: soossman 2012-12-20 16:18

>>27
I find your second example rather confusing. Do you mean to and or or the two conditions together? Is there support for such a thing? I also find your syntax rather inconsistent.



[create-table shitposts

              [[id . [integer primary-key]]

               [content . string]

               [turtles . integer]]]



[insert-into shitposts

             [[content . "shitpost document here"]

              [turtles . 99]]]



[select-from shitposts

  [where [and [> post.turtles 20]

              [not [ilike post.content /%sage%/]]]]]

Name: Anonymous 2012-12-20 16:24

https://github.com/kripken/sql.js

Name: Anonymous 2012-12-20 16:25

>>15
XDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD
IMPLYING LELELELEL SCUH A /G/ENTOOBRO
E/G/IN FUCKING MEME QUOTES /G/RO

Name: Anonymous 2012-12-20 17:06

dubz

Name: Anonymous 2012-12-20 18:53

>>32

LOL OMG HE SAID IMPLYING XDDDDDDDDDDDDDDDDD

He made a perfectly reasonable post that was even on topic -- a rarity here on /prog/!

If you really feel compelled to make ``le ironic shitpost xdddd'', please at least confine yourself to doing it in shitty off-topic threads.

Name: Anonymous 2012-12-20 18:55

>>34
you're not welcome here, imageboard scum

Name: Anonymous 2012-12-20 18:57

>>32,33,35
back to /b/, please.

Name: Anonymous 2012-12-20 18:58

>>35

Your ``/G/RO XDDDDD'' shitposting is not nearly as funny as you imagine.

Cut it out.

Name: Anonymous 2012-12-20 20:14

>>31
sqlite3.c: open source proving to be a nasty mess as always.
You'd have to be a crazy mother fucker to use this.

Name: Anonymous 2012-12-20 21:27

>>37
there are desktop threads sorely needing your presence

Name: Anonymous 2012-12-20 21:29

>>38
Careful, you might find yourself at the NASTY END OF MY SHOTGUN, cretin

What are some alternatives to a database?

1 Name: Anonymous 2012-12-19 19:03

2 Name: Anonymous 2012-12-19 19:07

3 Name: Anonymous 2012-12-19 19:07

4 Name: Anonymous 2012-12-19 19:10

5 Name: Anonymous 2012-12-19 19:20

6 Name: Anonymous 2012-12-19 19:21

7 Name: Anonymous 2012-12-19 19:40

8 Name: Anonymous 2012-12-19 22:38

9 Name: Anonymous 2012-12-20 0:15

10 Name: Anonymous 2012-12-20 0:26

11 Name: Anonymous 2012-12-20 2:05

12 Name: Anonymous 2012-12-20 3:13

13 Name: Anonymous 2012-12-20 3:27

14 Name: Anonymous 2012-12-20 4:04

15 Name: Anonymous 2012-12-20 4:15

16 Name: Anonymous 2012-12-20 4:26

17 Name: Anonymous 2012-12-20 4:39

18 Name: Anonymous 2012-12-20 4:44

19 Name: Anonymous 2012-12-20 4:45

20 Name: Anonymous 2012-12-20 4:57

21 Name: Le shiggy diggy quoter 2012-12-20 5:14

22 Name: Anonymous 2012-12-20 5:22

23 Name: angry web dev 2012-12-20 6:01

24 Name: Anonymous 2012-12-20 9:01

25 Name: Anonymous 2012-12-20 10:26

26 Name: Anonymous 2012-12-20 14:19

27 Name: Anonymous 2012-12-20 15:21

28 Name: Anonymous 2012-12-20 15:40

29 Name: Anonymous 2012-12-20 15:54

30 Name: soossman 2012-12-20 16:18

31 Name: Anonymous 2012-12-20 16:24

32 Name: Anonymous 2012-12-20 16:25

33 Name: Anonymous 2012-12-20 17:06

34 Name: Anonymous 2012-12-20 18:53

35 Name: Anonymous 2012-12-20 18:55

36 Name: Anonymous 2012-12-20 18:57

37 Name: Anonymous 2012-12-20 18:58

38 Name: Anonymous 2012-12-20 20:14

39 Name: Anonymous 2012-12-20 21:27

40 Name: Anonymous 2012-12-20 21:29

Name: Anonymous 2012-12-19 19:03

Name: Anonymous 2012-12-19 19:07

Name: Anonymous 2012-12-19 19:07

Name: Anonymous 2012-12-19 19:10

Name: Anonymous 2012-12-19 19:20

Name: Anonymous 2012-12-19 19:21

Name: Anonymous 2012-12-19 19:40

Name: Anonymous 2012-12-19 22:38

Name: Anonymous 2012-12-20 0:15

Name: Anonymous 2012-12-20 0:26

Name: Anonymous 2012-12-20 2:05

Name: Anonymous 2012-12-20 3:13

Name: Anonymous 2012-12-20 3:27

Name: Anonymous 2012-12-20 4:04

Name: Anonymous 2012-12-20 4:15

Name: Anonymous 2012-12-20 4:26

Name: Anonymous 2012-12-20 4:39

Name: Anonymous 2012-12-20 4:44

Name: Anonymous 2012-12-20 4:45

Name: Anonymous 2012-12-20 4:57

Name: Le shiggy diggy quoter 2012-12-20 5:14

Name: Anonymous 2012-12-20 5:22

Name: angry web dev 2012-12-20 6:01

Name: Anonymous 2012-12-20 9:01

Name: Anonymous 2012-12-20 10:26

Name: Anonymous 2012-12-20 14:19

Name: Anonymous 2012-12-20 15:21

Name: Anonymous 2012-12-20 15:40

Name: Anonymous 2012-12-20 15:54

Name: soossman 2012-12-20 16:18

Name: Anonymous 2012-12-20 16:24

Name: Anonymous 2012-12-20 16:25

Name: Anonymous 2012-12-20 17:06

Name: Anonymous 2012-12-20 18:53

Name: Anonymous 2012-12-20 18:55

Name: Anonymous 2012-12-20 18:57

Name: Anonymous 2012-12-20 18:58

Name: Anonymous 2012-12-20 20:14

Name: Anonymous 2012-12-20 21:27

Name: Anonymous 2012-12-20 21:29