Page 1 of 2 12 LastLast
Results 1 to 25 of 31
  1. #1
    Dislocated Member
    Neo's Avatar
    Join Date
    May 2011
    Last Online
    31-10-2021 @ 03:34 AM
    Location
    Nebuchadnezzar
    Posts
    10,609

    Database platform ideas?

    I've got a cunning plan that involves creating a technical database for training and standardisation purposes. I need info about the best product to suit that need. There are certain basic requirements I'm considering at this point.

    Open source software would be ideal if it meets security requirements, or a software package for a one off price as a template that I can copy and distribute the database on.

    Copyright protection of course can be hacked, but any or all of these: coding in the software to prevent direct copying, restricted or limitations to access, one time keygen type activation.

    The ideal format is a wiki, and it needs to look slick which probably rules out most open source, plus it needs to hold photo's, word docs and powerpoints.

    A very useful and flexible wiki is SharePoint on Microsoft 360, it would be a good platform, but I don't want to limit distribution only to those that are using Office.

    Ok thanks in advance.
    Life should not be a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming "Wow! What a Ride!"

  2. #2
    DRESDEN ZWINGER
    david44's Avatar
    Join Date
    Aug 2011
    Last Online
    @
    Location
    At Large
    Posts
    21,355
    Never a better excuse to visit Prague,if one needed

    Firebird Big Databases: free seminar in Prague (November 13, 2015)
    Firebird Project invites developers and administrators of big Firebird databases to the free seminar devoted to big Firebird databases: optimization, high availability, backups and maintenance.
    Sponsors of these seminars are Moscow Exchange (Platinum sponsor), IBSurgeon and IBPhoenix.

    This seminar requires an invitation. If you have a Firebird database more than 200Gb in size, please send us request (name of attendee, company name, database size, Firebird version, number of users, etc). We will confirm or decline your application shortly. Please send your requests asap, since there is not so much time left and seats are limited.
    More details and schedule of the seminar is here.
    Quote Originally Posted by taxexile View Post
    your brain is as empty as a eunuchs underpants.
    from brief encounters unexpurgated version

  3. #3
    Dislocated Member
    Neo's Avatar
    Join Date
    May 2011
    Last Online
    31-10-2021 @ 03:34 AM
    Location
    Nebuchadnezzar
    Posts
    10,609
    Firebird, that's interesting David.
    I wouldn't need 200Gb though, probably a 10th of that.
    I'll certainly look at what they have to offer though.

    Cheers

  4. #4
    DRESDEN ZWINGER
    david44's Avatar
    Join Date
    Aug 2011
    Last Online
    @
    Location
    At Large
    Posts
    21,355
    I'm no expert on this so do some research my friend n Prag worked with AVG and has moved into sales now.

    I guess horses for courses depends on your budget, security needs.
    Last edited by david44; 29-10-2015 at 06:00 AM.

  5. #5
    Thailand Expat
    Join Date
    Oct 2015
    Last Online
    16-07-2021 @ 10:31 PM
    Posts
    14,636
    obviously you haven't done your research on that topic

    use google, dozens of existing database platform

    but again, your objectives are clear as mud so who knows what you are trying to do here, as a database platform is not really a hobbie project

  6. #6
    The Pikey Hunter
    Gerbil's Avatar
    Join Date
    Jan 2006
    Last Online
    @
    Location
    Roasting a Hedgehog
    Posts
    12,355
    MS SQL Express. It's free and better than 95% of the shit out there pretending to be database software.

  7. #7
    Custom Title Changer
    Topper's Avatar
    Join Date
    Dec 2007
    Last Online
    Yesterday @ 11:57 PM
    Location
    Bangkok
    Posts
    12,225
    Quote Originally Posted by Gerbil
    MS SQL Express. It's free and better than 95% of the shit out there pretending to be database software.
    Twas going to be my recco as well.

  8. #8
    Dislocated Member
    Neo's Avatar
    Join Date
    May 2011
    Last Online
    31-10-2021 @ 03:34 AM
    Location
    Nebuchadnezzar
    Posts
    10,609
    Excellent thanks guys It's actually more beneficial to ask the question on TD and wait for someone knowledgeable to come up with suggestions on these kind of matters, than trawling the web comparing reviews etc, I just don't have the time.

  9. #9
    Dislocated Member
    Neo's Avatar
    Join Date
    May 2011
    Last Online
    31-10-2021 @ 03:34 AM
    Location
    Nebuchadnezzar
    Posts
    10,609
    Quote Originally Posted by CSFFan View Post
    Quote Originally Posted by Gerbil
    MS SQL Express. It's free and better than 95% of the shit out there pretending to be database software.
    Twas going to be my recco as well.
    Looking at the options I'll download the LocalDB version while I get to grips with it. I don't need to administer the database while I'm writing it and assume the 3rd party would run SQL with admin options. Also I'm not a coder, hence why I'm looking for a platform rather than a program. It's going to be a long term project anyway.

    LocalDB (SqlLocalDB.msi)
    • LocalDB is a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. It can be bundled with Application and Database Development tools like Visual Studio and or embedded with an application that needs local databases.
    Express (SQLEXPR_Architecture_Language.exe)
    • Express edition includes the SQL Server database engine only. Best suited to accept remote connections or administer remotely.
    Express with Tools (SQLEXPRWT_Architecture_Language.exe)
    • This package contains everything needed to install and configure SQL Server as a database server including the full version of SQL Server 2014 Management Studio. Choose either LocalDB or Express depending on your needs above.
    SQL Server Management Studio Express (SQLManagementStudio_Architecture_Language.exe)
    • This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, full version of SQL Server 2014 Management Studio, etc. Use this if you already have the database and only need the management tools.
    Express with Advanced Services (SQLEXPRADV_Architecture_Language.exe)
    • This package contains all the components of SQL Server Express including the full version of SQL Server 2014 Management Studio. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.
    Windows on Windows (WoW64) support (SQLEXPR32_Architecture_Language.exe)
    • SQL Server Express with WoW64 support is a version of SQL Server 2014 Express core that supports 32-bit applications on both 32-bit and 64-bit (WoW) operating systems.
    https://www.microsoft.com/en-gb/download/details.aspx?id=42299

  10. #10
    Thailand Expat
    Join Date
    Oct 2015
    Last Online
    16-07-2021 @ 10:31 PM
    Posts
    14,636
    Quote Originally Posted by Neo
    The ideal format is a wiki, and it needs to look slick which probably rules out most open source, plus it needs to hold photo's, word docs and powerpoints.
    I think you are confusing database back end and front end,

    Quote Originally Posted by Neo
    more beneficial to ask the question on TD and wait for someone knowledgeable to come up with suggestions
    you got to be joking, right ?

  11. #11
    Thailand Expat

    Join Date
    Mar 2011
    Last Online
    25-03-2021 @ 08:47 AM
    Posts
    36,437
    Jaysus...It really is Butters...Welcome back, mate...

  12. #12
    Thailand Expat
    Join Date
    Oct 2015
    Last Online
    16-07-2021 @ 10:31 PM
    Posts
    14,636
    any update ?

    I guess when you have no clue, even google can't help you

  13. #13
    Custom Title Changer
    Topper's Avatar
    Join Date
    Dec 2007
    Last Online
    Yesterday @ 11:57 PM
    Location
    Bangkok
    Posts
    12,225
    Quote Originally Posted by Dragonfly
    I think you are confusing database back end and front end,
    I'm guessing you're a back end sort....

  14. #14
    Thailand Expat
    BigRed's Avatar
    Join Date
    May 2006
    Last Online
    10-07-2018 @ 02:43 AM
    Location
    Hope Valley nr. Sheffield
    Posts
    1,112
    I'm a database consultant

    that's a bit irrelevant because butters is right , you are confusing front end with back end. I suspect you don't even really need a database. I think Azure would be a good start.
    see Pizza as a Service ? On Prem, IaaS, PaaS and SaaS Explained through Pie (not Pi) // Ektron for a guide to the various flavours of XaaS

  15. #15
    Dislocated Member
    Neo's Avatar
    Join Date
    May 2011
    Last Online
    31-10-2021 @ 03:34 AM
    Location
    Nebuchadnezzar
    Posts
    10,609
    Quote Originally Posted by BigRed View Post
    I suspect you don't even really need a database. I think Azure would be a good start.
    I'll try out SQL when I get some time.
    Last edited by Neo; 02-11-2015 at 05:40 AM.

  16. #16
    Thailand Expat
    Join Date
    Oct 2015
    Last Online
    16-07-2021 @ 10:31 PM
    Posts
    14,636
    Quote Originally Posted by Neo
    I'll try out SQL when I get some time.

  17. #17
    Dislocated Member
    Neo's Avatar
    Join Date
    May 2011
    Last Online
    31-10-2021 @ 03:34 AM
    Location
    Nebuchadnezzar
    Posts
    10,609
    Quote Originally Posted by BigRed View Post
    I suspect you don't even really need a database.
    If you're a consultant, and you read the OP fully, there should be enough info in it for you to give me a more definitive answer than 'I suspect'. I'm quite happy to look at any constructive advice on this.
    Last edited by Neo; 02-11-2015 at 04:44 PM.

  18. #18
    Dislocated Member
    Neo's Avatar
    Join Date
    May 2011
    Last Online
    31-10-2021 @ 03:34 AM
    Location
    Nebuchadnezzar
    Posts
    10,609
    Quote Originally Posted by Dragonfly View Post
    Quote Originally Posted by Neo
    I'll try out SQL when I get some time.
    Butters, if you were to construct a technical manual of 500+ pages that would meet the requirements of learners, employers, legislative watchdogs and certification boards, on top of your regular work, how long do you think that would take you to write, edit and proof?


  19. #19
    Thailand Expat
    Join Date
    Oct 2015
    Last Online
    16-07-2021 @ 10:31 PM
    Posts
    14,636
    Quote Originally Posted by Neo
    Butters, if you were to construct a technical manual of 500+ pages that would meet the requirements of learners, employers, legislative watchdogs and certification boards, on top of your regular work, how long do you think that would take you to write, edit and proof?
    funny you mention that as I was consulted for projects like that before, quite easy, and guess what, database platform has nothing to do with the successful delivery of such projects

    anyway it's above your paygrade, why would you take on such a job when you clearly don't have the skills, is just bizarre

    if it's a hobby project, use Google and learn something, for once

  20. #20
    Dislocated Member
    Neo's Avatar
    Join Date
    May 2011
    Last Online
    31-10-2021 @ 03:34 AM
    Location
    Nebuchadnezzar
    Posts
    10,609
    It's a simple question Butters, no need to make it into a drama, how long would it take you?


  21. #21
    Thailand Expat
    Join Date
    Oct 2015
    Last Online
    16-07-2021 @ 10:31 PM
    Posts
    14,636
    you lazy fool, I am not here to do your job

    anyway, you are clueless as ever, and bumping old threads to disguise your incompetence is just another way to prove what kind of fool you are

  22. #22
    Custom Title Changer
    Topper's Avatar
    Join Date
    Dec 2007
    Last Online
    Yesterday @ 11:57 PM
    Location
    Bangkok
    Posts
    12,225
    Quote Originally Posted by Dragonfly
    and bumping old threads to disguise your incompetence is just another way to prove what kind of fool you are
    It did bait you into answering the OP though....

  23. #23
    R.I.P.
    DrB0b's Avatar
    Join Date
    Dec 2006
    Last Online
    @
    Location
    ALL GLORY TO THE HYPNOTOAD
    Posts
    17,118
    Neo, from what you say in the OP it doesn't sound like you want a database. It sounds rather more like what you're looking for is a document management system. Is that the case?

    This is an example of a document management system https://www.alfresco.com/solutions/document-management

    while this is an example of a database http://www.mysql.com/

  24. #24
    Dislocated Member
    Neo's Avatar
    Join Date
    May 2011
    Last Online
    31-10-2021 @ 03:34 AM
    Location
    Nebuchadnezzar
    Posts
    10,609
    Thanks Bob, the Alfresco platform is very interesting, it has a demo on the website I can try when I have some time, is it something you've used or is it recommended? I use MS Sharepoint with work and want something similar, but self contained. I'm using 'database' as a generic term for a body of information that can be indexed and cross referenced, so yes document management would be a better term in this case. IT isn't my role and things have moved on from Wordpress so I appreciate the input.

  25. #25
    Dislocated Member
    Neo's Avatar
    Join Date
    May 2011
    Last Online
    31-10-2021 @ 03:34 AM
    Location
    Nebuchadnezzar
    Posts
    10,609
    Quote Originally Posted by Dragonfly View Post
    I was consulted for projects like that before, quite easy, and guess what, database platform has nothing to do with the successful delivery of such projects
    Interesting, how long have you had your IT consultancy business.?

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •