|
Are there any alternatives to MS Access around yet?
From what I can find things like SQLLite, Firebird, SQL CE etc are fine for local usage, and the others like SQLExpress, MariaDB all require servers (or at least software installed to host them).
I can't find one that has Access's standalone ability, as our current situation is access databases on LAN/WAN shares. So if there is something that can replace that?
The clients are likely to be C# WPF.
|
|
|
|
|
cjb110 wrote: From what I can find things like SQLLite, Firebird, SQL CE etc are fine for local usage,
That's the category that Access falls in.
cjb110 wrote: I can't find one that has Access's standalone ability
If you want a database-file without a server, you'll be looking at either access, or a single-file database like SQLite. If your data is accessed by multiple people from several workstations, then you DO want a server.
There's a button in your Access-IDE that upgrades the entire database to Sql Server. Install Sql Server Express (it's free) on a PC that the users have access to.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
 Your answer is exactly what I was expecting.
We've an internal issue in that getting new virtual servers are a long and overly expensive process and brings up 'which dept pays for this' problem. So I wanted to make sure that there wasn't alternatives...
|
|
|
|
|
You're welcome
|
|
|
|
|
cjb110 wrote: I can't find one that has Access's standalone ability
CSV files? 
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Per your other answer - where would you put Access if that was your solution? It would need to be somewhere all of the clients could reliably access it.
Same thing applies to a standard server database.
As for the internal management issue. Put it on a supervisors computer. No one works til that person starts up their computer. Everyone goes home or takes a vacation when that computer is off.
|
|
|
|
|
Access mdb's currently sits on various SAN locations, along side their other stuff like word and excel files.
A standard server database doesn't does it...but yea I know what you mean.
And unfortunately our various user bases are a bit big for the last idea to be feasible.
|
|
|
|
|
I see.
Maybe looking into clustering with embedded databases???
Not sure that is even feasible given that generally embedded would be one client but there might be one or two out there that supports that.
|
|
|
|
|
|
Please describe in brief. It was asked during one of my interviews.
|
|
|
|
|
|
Thanks Peter. This is what I was looking for. It was an easy illustration.
Could you please help me - Which book or link is better to learn more about design patters?
|
|
|
|
|
ankum16 wrote: It was asked during one of my interviews.
Curious, what company, and for which position?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
One which you won't want.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Yes, but I want to note the name just to be sure, and for any future reference. Works wonders with the "permalink" button.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
|
I think now I know the answer..
Possible relationship between two classes are:
1. Association
2. Aggregation
3. Composition
4. Generalization
|
|
|
|
|
hey guys
i'm trying out MVC with vs2013 and liking it but... the EF stuff is not to my liking as it seems really overkill for the sorts of web projects i do
after a couple of days of head banging i think i understand the basics enough to build what i want but now i'm kinda stuck on how to implement logins
are there any docs that might help? all those i find are referencing the MS solution and hence EF and the whole shooting match - i wanted something more lightweight or some docs on how to roll my own
thanks in advance
"mostly watching the human race is like watching dogs watch tv ... they see the pictures move but the meaning escapes them"
|
|
|
|
|
l a u r e n wrote: i'm kinda stuck on how to implement logins
You implement them with a user-unique salt, and a strong hash. Login-logic is contaminated with security-issues and would make a bad example on how to remove the dependency to EF.
Basically, you'd want to access a database from MVC, as shown on w3schools[^].
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
thanks man - that looks great
"mostly watching the human race is like watching dogs watch tv ... they see the pictures move but the meaning escapes them"
|
|
|
|
|
In our development team there is currently a trend to use "out of the box" solutions for different purposes. For example we now introduce a Node.js application using coffee script and iced coffee script beside our PHP application.
Sure - for most complex programming tasks there is already a solution out there which may be well developed and thought-out. But isn't it a high risk of making yourself dependent on these solutions when thinking a few years in the future? Most of these "frameworks" are imported via composer, you have to care about dependencies and updates. Also it gets harder to keep the overview of all the different solutions and technologies you are using and finding people who really understand how they are working. I am a fan of "simple" specific solutions and less dependencies and that brought us very far with our platform. It may be not the most performant one, but it is easy to understand for new people in the team, very stable and easy to maintain.
On the other hand I see the advantages of extending your application in a modular way - frameworks can be exchanged if they are programmed properly. Using new technologies can help you to find an elegant and easy way to solve complex problems and keep your code clean. And for sure - I don't want to be the "blocker" in the team who is always resisting changes.
What are your experiences?
|
|
|
|
|
Member 10873294 wrote: What are your experiences?
One of my favourite quotes; "Find dependencies - and eliminate them!".
In Defense of Not-Invented-Here Syndrome[^].
Sounds logical to me, coming from WinForms; but I heard the web is interconnected, and these modules modulate themselves. Don't they?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I don't know how many time I heard "Don't reinventing the wheel". But yes reinvent the wheel. Are our car still build with wood or rock wheels?
|
|
|
|
|
B413 wrote: Are our car still build with wood or rock wheels?
I reckon Kevlar[^], but I'm not quite sure - I never owned one
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
In the past I worked in a team of 100 developers on a very big project. The rule was to build everything in the house and avoid "out of the box" solutions. But we where 100 developers, we had the budget, the time and that was the good period and there wasn't a lot of good "out of the box" solutions.
After that I worked in smallest team with people pretending working on big project and it's probably true from their point of view but for me, because of my background, it was small teams and small projects. according to my experience in smallest team developers prefer to work with many "out of the box" solutions. Most of the time they don't have the budget or time to build their own solutions.
I insisted on the "pretending working on big project" because I often read information about people saying they use a lot of "out of the box" solutions in their "big" team or in their previous experience. But I can't imagine how they do when they have to manage their team, new developers and competencies, branching management with 5 or more versions at the same time, and trying to maintain all version of all your thirds party tools. As you said it's impossible to maintain a big project when you have to care about dependencies and updates of these third party frameworks.
I personally divide the developer in two categories just for fun. The alchemist and the magician. The first group are the developers that prefer to compose their code with "out of the box" solutions. The second group are the developers that prefer to build themselves everything. Of course most of people are somewhere between these two extreme.
EDIT -- I just learn that the term of Voodoo programmer already exists. My Alchemists are these Voodoo programmers.
modified 20-Jun-14 2:54am.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
