• Nicolas Hourcard

    Nicolas Hourcard

    5 months ago
    Hi @Sam welcome !
  • Nicolas Hourcard

    Nicolas Hourcard

    5 months ago
    Hi folks, ahead of easter let us share this presentation from our CTO Vlad to CMU Database with Andy Pavlo!

    https://www.youtube.com/watch?v=AxxutZ0v3HE

    Nicolas Hourcard
    1 replies
    Copy to Clipboard
  • s

    Sam

    5 months ago
    I can't seem to find a way to view the values in a timestamp column as the epoch unix values when I use the web console. It only returns as formatted date and time. Is there an easy way to do that?
    s
    Andrey Pechkurov
    3 replies
    Copy to Clipboard
  • Krisztián Körmöndi

    Krisztián Körmöndi

    5 months ago
    Hi, I'm sorry for bothering you. I'm trying to build a monitoring webapp. I'm testing the questdb, but I have not been receiveng any reaction to INSERT sql command. Could you please help? I'm attaching the testcode what I'm using. Please see below.
    Properties properties = new Properties();
        properties.setProperty("user", censored);
        properties.setProperty("password", censored);
        properties.setProperty("sslmode", "disable");
    
        final Connection connection = DriverManager.getConnection("jdbc:<postgresql://censored:8812/qdb>", properties);
        connection.setAutoCommit(false);
    
        final PreparedStatement statement = connection.prepareStatement("CREATE TABLE IF NOT EXISTS trade (ts TIMESTAMP, name STRING , value INT) timestamp(ts)");
        statement.execute();
    
        try (PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO trade (ts, name, value) VALUES (?, ?, ?)")) {
            preparedStatement.setTimestamp(1, new Timestamp(io.questdb.std.Os.currentTimeMicros()));
            preparedStatement.setString(2, "abc");
            preparedStatement.setInt(3, 123);
            preparedStatement.execute();
        }
        System.out.println("Done");
        connection.close();
    }
    Krisztián Körmöndi
    Vlad
    2 replies
    Copy to Clipboard
  • Cobalt L

    Cobalt L

    5 months ago
    hello, I am working on fixing the trailing numbers of double conversions, https://github.com/questdb/questdb/issues/297, the problem seems to be solved now. But some pre-exist tests now fail because their expected value has trailing digits, would appreciate some advice on how to deal with it. Can I just delete those tailing digits?
    Cobalt L
    1 replies
    Copy to Clipboard
  • Nicolas Hourcard

    Nicolas Hourcard

    5 months ago
    welcome @Dipen Thakkar!
  • Dipen Thakkar

    Dipen Thakkar

    5 months ago
    Thank you Nicholas!
    Dipen Thakkar
    Nicolas Hourcard
    3 replies
    Copy to Clipboard
  • Nicolas Hourcard

    Nicolas Hourcard

    5 months ago
    Hi everybody, we just posted our brand new crypto demo on Reddit Programming, would appreciate upvotes and/or comments! Thanks allhttps://www.reddit.com/r/programming/
  • Miguel Arregui

    Miguel Arregui

    5 months ago
    Well done @Isabella Qiao on merging this https://github.com/questdb/questdb/pull/2000 and thank you very much for your contribution!
    Miguel Arregui
    1 replies
    Copy to Clipboard
  • Pei

    Pei

    5 months ago
    @Olufemi Alabi welcome! what are you currently working on? 🙂