Current Status of New Project

[beyastard]

Little do you know I am working on a side-project due to the fact I ran into a bit of a problem...

The many new features I'm putting together for this project ran into the limitations of the SQLite
database I incorporated into the editor. Because of this, I spent nearly two days searching for
a viable solution to this problem.

One of the disadvantages of SQLite is it has its base in C - hence, unmanaged code running in a
managed program. SQLite, also, has a very small subset of SQL thereby running into its limitations
is quite simple.

I've considered FireBird for the embedded database but it, too, has its limitations, mainly being
it has no text search capabilities unless you get a third-party add-on.

All in all, I've decided to write my own embedded database system completely in C#...

[Swoosh91]

Just out of interest - what limitations did you run into with sqlite?

[80085]

I laugh hysterically every time das argues, rages, or claims to do anything himself. Then I simply die when his personal pet Loz shows up to defend him.

Also, ragezone was never good. Stop talking about "the old days", faggots.

erm who are you?

[Swoosh91]

I laugh hysterically every time das argues, rages, or claims to do anything himself. Then I simply die when his personal pet Loz shows up to defend him.

Also, ragezone was never good. Stop talking about "the old days", faggots.

Someone has been spending too much time on /b/ here...

[beyastard]

Just out of interest - what limitations did you run into with sqlite?

SQLite does not support functions, procedures, or floats. Other things not supported are
expressions. And, since I don't know whether or not my project will be run on 32 or 64 bit
machines, SQLite is unable to promote across 32 and 64 bits or across .net runtimes.

[Swoosh91]

Yeah true, no stored procedures is a bummer. It supports float though - check "real" datatype :)

I'm interested how you will solve your own flatfile database problem. if you create a format which supports stored procedures, that'd be cool. Never did that, since all the logic I use normally resides in some dll or internal class.

[DaMadBoy]

erm who are you?

He's the guy who pulled a hissy in my forums because I wouldn't increase my server rates

@beyastard I'm liking what you have done with your project so far, looking forward to actually being able to test it. Do you have any kind of time frame for when it might be ready for testing?

[gunse]

lol...
You should try your hand at making some tools yourself if they impresses you that much, it takes no time at all to learn and there are many many examples. No previous experience is required. I can't help but notice that its only those who never contribute who are writing silly posts like the one above.

This tool is a step in the right direction but its hardly breakthrough, control yourself ladies.

Hi ladies :-) unfortunately u exactly didnt get what i mean then u judge it, nice one :-) wise one :p so be it hahaha try to get sleep dude and positive thinking :-) thx anyway nice chat! And i m not receive "like" for nothing :-)

[beyastard]

Yeah true, no stored procedures is a bummer. It supports float though - check "real" datatype :)

I'm interested how you will solve your own flatfile database problem. if you create a format which supports stored procedures, that'd be cool. Never did that, since all the logic I use normally resides in some dll or internal class.

I don't have to solve a flatfile database problem; not using one. I'm making my own SQL compliant
database format. I'm working on the scripting engine right now.

When I began work on this, I couldn't come up with anything to name the database so I called it
the X Database, or XDB. I suppose I'm satisfied with the name...

To give a hint at the extent of the database engine, here is a class for multiplication in the
scripting engine:

using XDB.Engine.Internal;

namespace XDB.Engine.Core.Scripting
{
    internal class Multiplication : Signature
    {
        internal Multiplication(string name, int groupId)
            : base(name, groupId, Operations.Nomark, Priorities.Mutliplication, XDBType.Unknown)
        {
            AddParameter(XDBType.Unknown);
            AddParameter(XDBType.Unknown);
        }

        internal override Signature DoCloneSignature()
        {
            return new Multiplication(new string(Name), Group)
            {
                Entry = Entry
            };
        }

        protected override void OnFixReturnTypeAndParameters(Collector collector, int offset, XDBType newType)
        {
            var returnType1 = collector[offset].Signature.ReturnType;
            var returnType2 = collector[offset + 1].Signature.ReturnType;

            SetParameterType(0, returnType1);
            SetParameterType(1, returnType2);

            base.OnFixReturnTypeAndParameters(collector, offset, Summation.ReturnXDBType(returnType1, returnType2));
        }

        protected override void OnExecute(ProcedureCode pcode, int entry, Connection connection,
            DataStorage contextStorage, Row contextRow, ref bool bypassNextGroup, Row rowResult)
        {
            var pCodeUnit1 = pcode[entry];
            var pCodeUnit2 = pcode[entry + 1];

            pCodeUnit1.ResultColumn *= pCodeUnit2.ResultColumn;
        }
    }
}

@twister: not sure when it'll be ready for release yet. I'm a bit tied up with the database feature of
the project.

[Djinn]

It looks great bro. Keep up the good work, and i read this whole thread ,don't mind the haters. if anything there a good laugh. xD

[343]

How are things coming Beyastard?

[beyastard]

How are things coming Beyastard?

I have completely scrapped the original project as I've decided to make the program completely
extensible. Everything is going to be a plugin. I will, also, write how anyone can extend its
functionality by writing a plugin for it. The main program is simply a plugin manager so, depending
on the plugin, it can be anything at all. I hope to have a release in a few days with a few
plugins while I make more.

[Psytrac]

that's an interesting twist. would be nice to see it as it was in rage though. been looking forward to it

[loko9988]

write to me. help with fully structures.
task el and another.
for latest version

[derpules]

.....