Recommendations on nosql for embedded - Database Discussion Boards

Re: Join or the nomemclature for join using EF in c#

jkirkerx29-Nov-16 10:58

29-Nov-16 10:58

I went too far on duplicating fields in the shopping cart.
Now that I have the Automatic Migration working, I think I'll trim that down.

Globalism is Socialism on a planetary scale.

Re: Join or the nomemclature for join using EF in c#

jkirkerx29-Nov-16 11:12

jkirkerx

29-Nov-16 11:12

I shorted it down to this, and will just do a join to the master product table.
Would you include the price or leave that out as well?

public class SHOPPING_CART
    {
        [Key()]
        [Column(Order = 1)]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int cart_ID { get; set; }

        [Required]
        public int customer_ID { get; set; }

        [Required]
        [MaxLength(80)]
        public string customer_accountName { get; set; }

        [Required]
        public DateTime timeStamp { get; set; }

        [Required]
        [MaxLength(80)]
        public string item_Type { get; set; }

        [Required]
        public int item_ID { get; set; }

        [Required]
        public int item_Qty { get; set; }        

    }

Globalism is Socialism on a planetary scale.

Re: Join or the nomemclature for join using EF in c#

Richard Deeming30-Nov-16 2:10

Richard Deeming

30-Nov-16 2:10

Since you don't seem to have quantity breaks or any other complicated calculations, and you're removing the cart once it's processed, I'd be inclined to leave the price on the product.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Join or the nomemclature for join using EF in c#

indian1436-Dec-16 11:43

indian143

6-Dec-16 11:43

Just out of the topic, but I am asking this here because I want to directly ask you, your caption says "Globalism is Socialism on a planetary scale", how, do you mean Socialism is nothing but imposing unwanted rules on mass people?, is it in that way? Smile | :)

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

Re: Join or the nomemclature for join using EF in c#

jkirkerx6-Dec-16 12:08

jkirkerx

6-Dec-16 12:08

I changed it to "21st century globalism is socialism on a planetary scale", makes more sense now.

I seriously doubt anyone cares why I think this now, and I would private message you why, but I think they removed the private message feature; can't find yours. And I don't want to violate the rules of the forum by posting my thoughts on this. But I do have a well detailed anwser for it.

21st Century Globalism has become Socialism on a planetary scale, in which the unequal treaties of the past have come back into play.

Re: Join or the nomemclature for join using EF in c#

indian1436-Dec-16 14:11

indian143

6-Dec-16 14:11

It doesn't matter for me my friend, its just your opinion as I will have mine, I respect your opinion but just asked what was your logic in it. We have both things in our genes that's to protect our territory and to cross territory, it came from animal genes that they were our fathers millions of millions of years back as per Darwin sir Smile | :)

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

modified 6-Dec-16 20:17pm.

Re: Join or the nomemclature for join using EF in c#

jkirkerx7-Dec-16 6:58

jkirkerx

7-Dec-16 6:58

21st Century Globalism has become Socialism on a planetary scale, in which the unequal treaties of the past have come back into play.

Recommendations on nosql for embedded

LasseL28-Nov-16 4:04

LasseL

28-Nov-16 4:04

I am writing a application that are going to run on small NAS servers using Java.

For that purpose I am looking for a nosql database that can be embedded in my application.

Another requirement I have is that is should be possible to connect to the database from remote clients.

Thats is, piece of cake. Smile | :)

Beside those two requirements I am prepared to adapt my application to the database.

I know for example of MongoDB, Neo4J and OrientDB but have no experience of running them on small CPUs.

Any tips, tricks or recommendations.

//lg

/happy amateur

Re: Recommendations on nosql for embedded

Afzaal Ahmad Zeeshan29-Nov-16 9:22

Afzaal Ahmad Zeeshan

29-Nov-16 9:22

Create your own engine for minimal XML-based data sources. Your programs will read, write the data to these XML data sources and you can relax while it works on low-power CPUs too. Smile | :)

I personally use JSON for my regular day tasks instead of XML, but you can select either, then write an engine for that; CRUD functions and a bit of validation etc.

Create, read, update and delete - Wikipedia[^]

The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

MySQL

Mycroft Holmes24-Nov-16 20:39

Mycroft Holmes

24-Nov-16 20:39

I've been faffing around with MariaDB with the view to converting our SQL Server Apps. First step is to convert out CRUD code generator. I'm used to SQL Server which insists that I prefix a parameter value with @ MySQL has no such rule and you can end up with something like

SQL

select *
from vwTestMAF
where TestMAFID = -1 or  TestMAFID = TestMAFID;

where the TestMAFID is both the field name and the parameter name and the query naturally does not work.

Is there a naming convention for MySQL parameter (prefixing the parameter name with @ did not work either!)

Never underestimate the power of human stupidity
RAH

Re: MySQL

Midi_Mick24-Nov-16 21:10

Midi_Mick

24-Nov-16 21:10

Perhaps qualifying the field names could help.

SQL

...where vwTestMAF.TestMAFID = -1 or vwTestMAF.TestMAFID = TestMAFID;

Cheers,

Mick
------------------------------------------------
It doesn't matter how often or hard you fall on your arse, eventually you'll roll over and land on your feet.

Re: MySQL

Mycroft Holmes25-Nov-16 22:13

Mycroft Holmes

25-Nov-16 22:13

Qualifying the names did the trick, I was hoping there was a standard convention the mysql users would recognise.

Re: MySQL

Michael_Davies24-Nov-16 21:35

Michael_Davies

24-Nov-16 21:35

The old MySQL method was to placehold with ? so and you had to add the values in the right order, currently MySQL uses @ and it works, not sure about MariaDB;

select *
from vwTestMAF
where TestMAFID = -1 or TestMAFID = ?;

What are some tricky/interesting SQL questions you were asked in interviews?

qptopm20-Nov-16 21:52

qptopm

20-Nov-16 21:52

What are some tricky/interesting SQL questions you were asked in interviews?

Sql For Beginners || Nursery Rhymes for kids

Re: What are some tricky/interesting SQL questions you were asked in interviews?

Afzaal Ahmad Zeeshan20-Nov-16 23:49

Afzaal Ahmad Zeeshan

20-Nov-16 23:49

A simple Google search could yield a great list of good and helpful resources about questions that are to be asked in interview,

Interview Questions For 2 Years Experience in SQL and C#[^]
SQL Interview Questions - tutorialspoint[^]
24 Essential SQL Interview Questions and Answers | Toptal[^]
SQL Interview Questions And Answers[^]

The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

Re: What are some tricky/interesting SQL questions you were asked in interviews?

Simon_Whale21-Nov-16 0:27

Simon_Whale

21-Nov-16 0:27

Have a google for Sql Central, that site offers a "question of the day" which allows you to keep brushed up on your SQL Server and TSQL skills.

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: What are some tricky/interesting SQL questions you were asked in interviews?

Eddy Vluggen21-Nov-16 1:12

Eddy Vluggen

21-Nov-16 1:12

qptopm wrote:
What are some tricky/interesting SQL questions you were asked in interviews?

Any detail from a book that is hardly used and therefore hard to remember. Most of these questions test your memory, not your understanding of how a database works.

Syntax is something you can look up quickly, but understanding never comes quick.

So, in your own words, what is a database, and when would I use one? Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Error???

Member 1116162519-Nov-16 17:28

Member 11161625

19-Nov-16 17:28

Hi,

I'm getting the following errors while creating Filestream features in Sql server???

How to solve this error,Please help me???

ERROR:-
Msg 1969, Level 16, State 1, Line 1
Default FILESTREAM filegroup is not available in database 'HumanResource'.

Thanks...

Re: Error???

Afzaal Ahmad Zeeshan20-Nov-16 9:38

Afzaal Ahmad Zeeshan

20-Nov-16 9:38

That is because you have to create that group, it is not provided in your database by default. You must enable it,

Getting Started with FILESTREAM Storage[^]:
FILESTREAM is not automatically enabled when you install or upgrade SQL Server. You must enable FILESTREAM by using SQL Server Configuration Manager and SQL Server Management Studio

So do that, then you will be able to overcome this error. A documentation is given here too, FILESTREAM (SQL Server)[^].

Default FileStream filegroup is not available in database 'DatabaseName'[^]

The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

Re: Error???

Daniel Jones19-Dec-16 17:42

Daniel Jones

19-Dec-16 17:42

Take a look at this link hope this will help you out: Msg 1969 Level 16 State 1 | SQL Server Portal[^]

--
Regards,
Daniel Jones

MySql 1093 Error: You can't specify target table 'c1' for update in FROM clause

Abhinav_00717-Nov-16 13:16

Abhinav_007

17-Nov-16 13:16

I am trying to execute the following update query:

update committees c1 set num_subcommittees = 
   case
   when parent_committee is not null then -1
   else (select count(*) from committees c2 where c2.parent_committee = c1.id)
   end;

But instead getting mySql 1093 error. The table structure is like this:

CREATE TABLE `committees` (
  `id` char(5) NOT NULL,
  `parent_committee` char(5) DEFAULT NULL,
  `name` char(200) DEFAULT NULL,
  `chairman` char(40) DEFAULT NULL,
  `ranking_member` char(40) DEFAULT NULL,
  `num_subcommittees` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Please comment.

Re: MySql 1093 Error: You can't specify target table 'c1' for update in FROM clause

Afzaal Ahmad Zeeshan20-Nov-16 23:51

Afzaal Ahmad Zeeshan

20-Nov-16 23:51

What is c1? Just use committees to update the table.

PHP Update Data in MySQL[^]

The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

Message Closed

11-Nov-16 11:33

Jassim Rahma

11-Nov-16 11:33

Message Closed

modified 11-Nov-16 17:44pm.

OT: Your signature...

Kornfeld Eliyahu Peter12-Nov-16 21:36

Kornfeld Eliyahu Peter

12-Nov-16 21:36

Your signature (Jassim) points to a site seems to be commercial... It is not really accepted here and can cause you to be banned for spamming...
Please remove it (or restore it to its previous value - your personal site)!

Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.

Re: OT: Your signature...

Mycroft Holmes12-Nov-16 21:48

Mycroft Holmes

12-Nov-16 21:48

I suspect it may be a site he created, or at least customised the template for!

Never underestimate the power of human stupidity
RAH

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.