Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


NameCrane Offloaded SQL is now in public BETA! - Page 3
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

NameCrane Offloaded SQL is now in public BETA!

1356713

Comments

  • Out of stock

  • digijdigij Member

    Love the simplicity of the product (create DBs, users, whitelist IPs in the UI). My use case - LLM creates data on workflow automation platform - last step: Data is stored in NameCrane Offloaded SQL DB, so it can be consumed later on. So in my case not so much offloaded but standalone DB.

    Thanked by 1kkrajk
  • sh97sh97 Member, Host Rep

    Will wait eagerly for the postgres stuff in EU and SG

    Thanked by 1nghialele
  • JabJabJabJab Member
    edited March 30


    I assume those buttons should copy value, they do not work - they not even buttons now :-D
    If you gonna waste time work on the UI please put some password generator (with sane rules ;')) into creating new user view.

    I've also mostly (OpenAI powered, fucking useless shit) migrated some data to this, it feels good, feels fast and responsive.

  • @JabJab said:

    I assume those buttons should copy value, they do not work - they not even buttons now :-D
    If you gonna waste time work on the UI please put some password generator (with sane rules ;')) into creating new user view.

    I've also mostly (OpenAI powered, fucking useless shit) migrated some data to this, it feels good, feels fast and responsive.

    32 million rows. Nice

  • SmigitSmigit Member
    edited March 30

    super minor thing, but on the add users page, if you select ‘all’ for permissions the other checkboxes are disabled, but on my display anyway its incredibly subtle to the point that initially I didn’t even notice boxes had gone read only. Maybe the text should respond too to help with readability.

    Also if invalid characters are used on the username, some red message might be warranted next to the username field to say there’s invalid characters. I was also able to submit a username that was just a space, and had the following user created: “sql22006_”. Looks like it gets truncated down and only the standard prefix is used as the name

    Edit: Database name is the same. Can supply an empty string that gets truncated down, and I assume isn’t really the intention and that you want at least 1 alphanumeric.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Smigit said:
    super minor thing, but on the add users page, if you select ‘all’ for permissions the other checkboxes are disabled, but on my display anyway its incredibly subtle to the point that initially I didn’t even notice boxes had gone read only. Maybe the text should respond too to help with readability.

    Also if invalid characters are used on the username, some red message might be warranted next to the username field to say there’s invalid characters. I was also able to submit a username that was just a space, and had the following user created: “sql22006_”. Looks like it gets truncated down and only the standard prefix is used as the name

    Edit: Database name is the same. Can supply an empty string that gets truncated down, and I assume isn’t really the intention and that you want at least 1 alphanumeric.

    That’s for sure a bug, will fix that in a few :) it sounds like a screwed up a preg match.

    Francisco

    Thanked by 1Smigit
  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said:

    I assume those buttons should copy value, they do not work - they not even buttons now :-D
    If you gonna waste time work on the UI please put some password generator (with sane rules ;')) into creating new user view.

    I've also mostly (OpenAI powered, fucking useless shit) migrated some data to this, it feels good, feels fast and responsive.

    It copies for me without issue. What browser are you on? I’ll make it more obvious that it’s a button.

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @BetaRacks said:
    What are its advantages over webhosting's own database?
    Will it be suspended when there is high cpu or high io?
    Is it possible to buy dedicated cpu, memory and io?

    Right. The idea is that you won’t get smacked by cloudlinux all the time if you have a bursty or busy website.

    Which means your site should have more resources for php and our nodes don’t go mental. We’ve had a lot of issues with db_governor when it’s trying to keep a dozen or two users in check.

    It’ll randomly lock up and eat every last bit of cpu it can (2400% on our ryzens) until we can ssh in (if we can) to kick it.

    Francisco

    Thanked by 1Frameworks
  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @poctopus said:
    Very good service, I am looking for this service.
    I want to confirm how long this free service can be used and when the official service will be available.

    I figure we will do the beta for a month or two. I want to beta test it in EU as well.

    Francisco

  • JabJabJabJab Member

    @Francisco said: It copies for me without issue. What browser are you on? I’ll make it more obvious that it’s a button.

    Oh fuck me. I tested it more... it works, if you click on the icon, not the whole span/div around it. Icon good, grey area bad. Please fix :')
    Mouse over effect, maybe some blink/flash/label/toast that you copied that?

    Chrome is up to date
    Version 134.0.6998.178 (Official Build) (64-bit)
    Windows, of course.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said:

    @Francisco said: It copies for me without issue. What browser are you on? I’ll make it more obvious that it’s a button.

    Oh fuck me. I tested it more... it works, if you click on the icon, not the whole span/div around it. Icon good, grey area bad. Please fix :')
    Mouse over effect, maybe some blink/flash/label/toast that you copied that?

    Chrome is up to date
    Version 134.0.6998.178 (Official Build) (64-bit)
    Windows, of course.

    On it then :) I’ll just attach a whole ass button to the right side instead of what’s usually for checkboxes.

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran
    edited March 30

    @JabJab said: Oh fuck me. I tested it more... it works, if you click on the icon, not the whole span/div around it. Icon good, grey area bad. Please fix :')
    Mouse over effect, maybe some blink/flash/label/toast that you copied that?
    Chrome is up to date
    Version 134.0.6998.178 (Official Build) (64-bit)
    Windows, of course.

    Give that a whirl, should be more sane.

    Francisco

    Thanked by 1JabJab
  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Smigit said:
    super minor thing, but on the add users page, if you select ‘all’ for permissions the other checkboxes are disabled, but on my display anyway its incredibly subtle to the point that initially I didn’t even notice boxes had gone read only. Maybe the text should respond too to help with readability.

    Also if invalid characters are used on the username, some red message might be warranted next to the username field to say there’s invalid characters. I was also able to submit a username that was just a space, and had the following user created: “sql22006_”. Looks like it gets truncated down and only the standard prefix is used as the name

    Edit: Database name is the same. Can supply an empty string that gets truncated down, and I assume isn’t really the intention and that you want at least 1 alphanumeric.

    This has been fixed 🐀

    Francisco

    Thanked by 2emgh Smigit
  • MoopahMoopah Member

    Nice product Fran, but I'll be waiting for when (hopefully) PostgreSQL is added.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @Moopah said: Nice product Fran, but I'll be waiting for when (hopefully) PostgreSQL is added.

    I need to go do a crash course on it :) Did some more visual tweaks. Should have a random password generator on the password field shortly.

    Francisco

  • agentmishraagentmishra Member, Host Rep

    no stock!

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said: If you gonna waste time work on the UI please put some password generator (with sane rules ;')) into creating new user view.

    This is now in place:

    Francisco

  • JabJabJabJab Member
    edited March 30

    Nice, thanks!

    More feedback: I've broken EDIT user. Maybe by not adding any permissions or by doing it too long [or going full numeric]?

    Created user with 60 characters long (no idea if you added the prefix sql[number]_ to the limit - I assume it's 64, sql[number]_ is longer than 4 so after the prefix one it should be shorter?).
    Clicking EDIT throws 500 in the POST with

    TypeError: in_array(): Argument #2 ($haystack) must be of type array, null given in /home/namecrane/public_html/templates_c/82f547e029de0c8af9eb05d4e54dd10aa39be11b_0.file.manage.tpl.php:90
    

    m=cranebase&id=21984 if you want to click as WHMCS user and debug.

  • varwwwvarwww Member

    just curious, how much is max_connections for each user?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @varwww said: Quote

    There's no limit at the moment, but we reserve the right to put something in the future if it's obviously abuse going on.

    Francisco

    @JabJab said: More feedback: I've broken EDIT user. Maybe by not adding any permissions or by doing it too long?

    So you edited a user, removed the permissions, and then did EDIT again and it shat itself?

    Francisco

    Thanked by 1varwww
  • JabJabJabJab Member
    edited March 30

    @Francisco said: So you edited a user, removed the permissions, and then did EDIT again and it shat itself?

    Nope, created one without selecting any permissions it seems the trick as just created new one, shorter and it acts the same. Seems you don't need to check any checkbox while creating user.

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said: Nope, created one without selecting any permissions it seems the trick as just created new one, shorter and it acts the same.

    Someones working hard to get that free service 👀

    Thanks, fixed. You'll probably have to delete and remake that user.

    Francisco

  • iSkyiSky Member

    @Francisco said:

    @poctopus said:
    Very good service, I am looking for this service.
    I want to confirm how long this free service can be used and when the official service will be available.

    I figure we will do the beta for a month or two. I want to beta test it in EU as well.

    Francisco

    any beta test on SG ? and if already officially, will SG included ?

  • JabJabJabJab Member
    edited March 30

    Works now :)

    I can also login to phpMyAdmin with that long ass username, but throws kinda warning/error for storing settings I guess.

    but this is probably phpmyadmin "feature" and not worth touching it ;')

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @JabJab said: but this is probably phpmyadmin "feature" and not worth touching it ;')

    It might be a compat issue between MySQL & MariaDB. I'll check the phpyadmin struct and shorten it as needed.

    I've changed the error display in the Users modal to be an alert box at the top instead of being misaligned on the right side of the button like it was.

    Francisco

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @iSky said: any beta test on SG ? and if already officially, will SG included ?

    SG will be a ways out. Mike & I will have to decide if we want to do this as a standalone product, or try to make it shared/resellers only.

    If we do it as a standalone I'd also throw a node in Kansas to cover mid-west USA.

    Francisco

  • Will there also be reseller plans for these?

  • FranciscoFrancisco Top Host, Host Rep, Veteran

    @BasToTheMax said:
    Will there also be reseller plans for these?

    We expect them to be resold from the get go, we aren't going to gatekeep these like we did Cranemail. The whole purpose of these is to be used/resold.

    Unless you mean an API w/ WHMCS/Blesta modules?

    Francisco

    Thanked by 1BasToTheMax
  • JabJabJabJab Member
    edited March 30

    Seems like disabled is not enabled ( :cookie: ) aka I can switch this to "Disabled" while creating or editing user, but it will always come back as Active/Enabled after clicking Save. Like it's not saving that field status and falling back to default?

    The phpMyAdmin Enabled/Disabled seems to be working fine.

Sign In or Register to comment.