Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

database engine

Name: hello 2013-07-13 4:33

hello

I am looking for a database engine that meets these requirements:

1. Provides an API that does not require passing commands as strings which are then parsed at runtime.
2. Runs in the same process as the client application. It's just a library.
3. Is under 600kb in size.

If nothing like this exists, I will write a minimal special purpose one for the bbs in r6rs scheme or common lisp.

Name: Anonymous 2013-07-13 4:56

You're a lisp idiot and will never know success. Lisp contradicts success.

Name: Anonymous 2013-07-13 5:08

>>2
Would you mind explaining each of the these statements:

1. What is a lisp idiot?
2. Why am I a lisp idiot?
3. What do you mean by success?
4. Why will I never have what you refer to as success?
5. What do you mean by Lisp?
6. Why does what you mean by Lisp contradict what you mean by success?

Name: Anonymous 2013-07-13 5:23

>>3
in r6rs scheme or common lisp
This shows you're a lisp idiot.
The fact that lisp contradicts success is a fact of life proven by previous lisp idiots.

Name: Anonymous 2013-07-13 5:31

>>5
Is under 600kb in size
Yeah, you have to write it yourself.

Name: Anonymous 2013-07-13 6:10

>>1
SQLite................Seriously you could not even figure this out....

Name: Anonymous 2013-07-13 6:32

>>6
Ijust fucking rea;liszed that sqlite does not nhave a fucking license. holy shit. the craziest bit? They will sell you one for $1000 if you want to.
For a one-time fee of US $1000.00 we will add your company name and contact information to a copy of the sample license agreement, sign the completed license, and send you the original signed copy by post and a scan of the signed document by email. You can make your purchase by calling our office at +1.704.948.4565 during US East Coast business hours, or sending email to sqlite@hwaci.com, or filling out the form below, whichever is most convenient for you.

Name: Anonymous 2013-07-13 6:59

>>1
It is on public domain, which should not be:
http://www.sqlite.org/copyright.html

Name: >>8 2013-07-13 7:05

s/>>1/>>7/
Near-sightedness, at its finest.

Name: Anonymous 2013-07-13 8:40

>>4
That only partially answers 2 and 6.

>>5
darn it.

>>6
I have not found a function for creating a prepared statement without going through the string based prepare functions.
http://www.sqlite.org/capi3ref.html

>>7
How strange.

Name: faceplam 2013-07-13 8:52

>>1010
http://wiki.call-cc.org/eggref/4/sqlite3
http://www.sqlite.org/sqlite.html

http://www.cliki.net/SQLite%20Lisp%20interface
http://common-lisp.net/project/cl-sqlite/

Name: Anonymous 2013-07-13 8:57

>>11
Those are nice to use, but if they use the sqlite3_prepare* functions then sql is parsed at run time. That's what I want to avoid. But since sqlite is totally open source, I could hack in another API in a fork.

Name: Anonymous 2013-07-13 9:05

>>12
Certainly...:
http://www.sqlite.org/lang_createtrigger.html

Is this your first time creating anything with a SQL DB? You might want to get started:
http://www.sqlite.org/docs.html

If you want an awesome BBS already made look at Synchronet:
https://en.wikipedia.org/wiki/Synchronet

That need to be rewritten in in C and Scheme.

Name: Anonymous 2013-07-13 9:25

>>13
Thanks for the link to Synchronet. Right now I'm aiming for a functional clone of shiichan that isn't a pile of shit (no offense shii) so I can host it without being vulnerable. But I'm not going to use any of that worse is better, parse-sql-strings-at-runtime-because-your-compiler-doesn't-have-a-turing-complete-preprocessor-that-can-transform-sql-strings-to-compiled-statements-at-compile-time shit.

Name: ニャー 2013-07-13 9:36

>>14
Offence not taken. But yeah, learn to make functions and triggers. You can automate most of the work on SQLite, and use Scheme for the scripting. I am just shocked that you did not even bother to search "Small[/Lite] Database" and could not find SQLite. It is the first result in the mayor search engines, even distributed ones.

Ah the days when BBS where starting out. Those where the days. mewBBS is still alive lol:
http://mewc.to/CGI/mewbbs.html

Name: Anonymous 2013-07-13 9:37

>>15
is...is it really you? *gasp*

Name: Anonymous 2013-07-13 9:40

>>16
Who do you have in mind? I am not Yuto Ikeno, who built mewBBS.

Name: Anonymous 2013-07-13 9:45

>>17
When you said offense not taken I assumed you were shii.

Name: Anonymous 2013-07-13 9:50

>>18
Ah no, everyone here knows Shiichan and Wakaba & Kareha are a pile of stupidity. Why I said not to take offence. Shii, never goes here, he has his own boards:
http://wakaba.c3.cx/sup/

Name: Anonymous 2013-07-13 9:51

>>18
Also, he only visits:
http://www.wakachan.org/
http://4-ch.net/

Name: Anonymous 2013-07-13 10:25

>>1
That's a really good idea, and since anything other than some equivalent to SQL tends to be unwieldy, scheme or lisp is the only language you can write it in.

I think various commenters are right that you should find an existing engine to extend.  Really what you want I think, is a collection of lisp macros that will call *any* database.

That solves what for me is the more interesting problem.  Running a db engine in your own process is probably trivial as long as you have access to the source.

Name: Anonymous 2013-07-13 11:25

>>21
Be my guest, and pick any:
http://cliki.net/Database

Name: Anonymous 2013-07-13 11:38

>>22
Nice.

Name: Anonymous 2013-07-13 11:42

>>22
An unorganized zoo of incomplete and bitrotten projects. I once spent two days combining their zlib and png encoder/decoder into a single png library, because all other depended on libpng, which is just bad.

Name: Anonymous 2013-07-13 12:32

>>24
Then contribute, leech.
Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List
All trademarks and copyrights on this site are owned by their respective parties. All comments and posts are the responsibility of their own posters.
- Tinychan + 2ch Mode -